If fuction with greater and less than not working

[susanaol]

Hi all,

I am using the below formula but when I have an Item with cost 70 and over excels pulls the "mid range" statement..what do I need to change so it pulls the "high range" text?

=IF(H2<=30.99,"LOW RANGE",IF(H2>=31,"MID RANGE",IF(H2<=69.99,"MID RANGE",IF(H2>=70,"HIGH RANGE","Needs Price"))))


Thanks in advance

 

[KBartmanovich]

=IF(A1<=30.99,"LOW RANGE",IF(A1<=69.99,"MID RANGE",IF(A1>=70,"HIGH RANGE","Needs Price")))

 

[lenze]

=IF(H2,IF(H2<=30.99,"LOW RANGE",IF(H2<=69.99,"MID RANGE","HIGH RANGE")),"Needs Price")

Note the structure. You don't need to test for >=31 or >=70

lenze

 

[susanaol]

Thanks so much!! it worked perfectly!