If fuction with greater and less than not working

susanaol

New Member
Joined
May 27, 2009
Messages
28
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 :confused:
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
Code:
=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
 

Watch MrExcel Video

Forum statistics

Threads
1,109,508
Messages
5,529,272
Members
409,859
Latest member
emperorgenghiskhan
Top