Trouble with Nested If Function

[HuckFinn]

Actual Salary (M9)	Minimum (T9)	1st. Qtr. (U9)	Market Rate (V9)	3rd Qtr. (W9)	Maximum (X9)	Quartile Position (Y9)
43680	31720	37010	42300	47585	52870	Q3

I am having trouble with the formula below:
=IF($M9<T9,"Below Min",IF($M9<=$U9,"Q1",IF($M9>$U9,"Q2",IF($M9>$V9,"Q3",IF($M9>$W9,"Q4",IF($M9>$X9,"Above Max"))))))

It is returning a Q2 in the Quartile Position, when I am expecting a Q3. The Actual Salary is greater than the Market Rate, but less than or equal to the 3rd Qtr. Any idea on where I am going wrong here?

 

[Larry Haydn]

When you are comparing a range of numbers using the > operator, always compare the values from the highest to the lowest.
When you are comparing a range of numbers using the < operator, always compare the values from the lowest to the highest.
In this case, the formula below gives you the correct answer:
=IF(M9<T9,"Below Min",IF(M9>X9,"Above Max",IF(M9>W9,"Q4",IF(M9>V9,"Q3",IF(M9>U9,"Q2",IF(M9>T9,"Q1"))))))

 

[bebo021999]

Using LOOKUP

=IFERROR(LOOKUP($M9,$T9:$X9,{"Q1","Q2","Q3","Q4","Over Max"}),"Below Min")

 

[HuckFinn]

Thank you! Both options work well for my needs. I appreciate the assist here.