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
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