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

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

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,131
Messages
5,527,020
Members
409,736
Latest member
maanbunty

This Week's Hot Topics

Top