Can you use two inequalities with the IF function ie IF 10<E5<20.

[CRICKETERRY]

In EXCEL I know you can use the IF function with one inequality eg IF E9>8
THEN....But can you make it do two inequalities at once eg if E9 is between
100 and 200 THEN... Any help much appreciated

 

[Hari Prasadh]

Hi,

One way

=IF((E9>100)*(E9<200),TRUE,FALSE)

You can use And, OR statement within IF.

Thanks a lot,
Hari
India

 

[Bob Phillips]

=IF(AND(E9>=100,E9<=200), True,False)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Cricketerry]

Many thanks for taking the time to reply- I'm still learning! Terry Sealey

 

[Cricketerry]

Many thanks for your reply. A great help. Terry Sealey