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

"Hari Prasadh" wrote:

Hi,

One way

=IF((E9100)*(E9<200),TRUE,FALSE)

You can use And, OR statement within IF.

Thanks a lot,
Hari
India

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