# If fuction with greater and less than not working

#### susanaol

##### New Member
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"))))

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

#### KBartmanovich

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

#### lenze

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

#### susanaol

##### New Member
Thanks so much!! it worked perfectly!

Replies
4
Views
86
Replies
1
Views
28
Replies
1
Views
49
Replies
3
Views
76
Replies
3
Views
62