Needing help with IF formula

[Caroline Travell]

Hi

I'm trying to write an IF formula but use a range of numbers, for example:

IF(M6>=15.4,"High 1st")

but the range needs to cover 14.5-15.4. How d oI include this in the formula?
Hope you can help

Thanks

Caroline

[#2]

Hi Caroline,

As variant that could be nested IF

=IF(M6>=15.4,"High 1st",IF(M6>=14.5,"High 2nd","Low"))

or LOOKUP

=LOOKUP(M6,{0,14.5,15.4},{"Low","High 2nd","High 1st"})

perhaps something else