Combination of +IF formulas

Hi,

I would love some help!

I have a number of formula which returns some text if the numbers are within a range, but I need to have them in one cell.

i.e. all the following formulas are in different cells and I need them in one...

=IF(((O7>=0)*(O7<=26))=1, "U", " ")
=IF(((O7>=27)*(O7<=35))=1, "L1P", " ")
=IF(((O7>=36)*(O7<=44))=1, "L1M", " ")
=IF(((O7>=45)*(O7<=53))=1, "L1D", " ")
=IF(((O7>=54)*(O7<=62))=1, "L2P", " ")
=IF(((O7>=63)*(O7<=71))=1, "L2M", " ")
=IF(((O7>=72)*(O7<=100))=1, "L2D", " ")

Is this possible?

Jon

You could set up a small table in two adjacent columns, like this:

. 0 ... U
27 ...L1P
36 ... L1M
45 ... L1D
54 ... L2P
63 ... L2M
72 ... L2D

Suppose this is in columns X and Y. Then you can use this formula:

=VLOOKUP(O7,$X:$Y,2)

instead of having multiple IFs.

Hope this helps.

Pete

pls try this formula

Formula:

Please Login or Register  to view this content.

Thank you everyone that was so helpful!

@Jonathan_Green You're Welcome. Glad to help . Thank You for the feedback.