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

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

Hi,

One way

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

You can use And, OR statement within IF.

Thanks a lot,
Hari
India

"CRICKETERRY" <[email protected]> wrote in message
news:[email protected]...
> 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

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

--

HTH

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


"CRICKETERRY" <[email protected]> wrote in message
news:[email protected]...
> 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

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

"Hari Prasadh" wrote:

> Hi,
>
> One way
>
> =IF((E9>100)*(E9<200),TRUE,FALSE)
>
> You can use And, OR statement within IF.
>
> Thanks a lot,
> Hari
> India
>
> "CRICKETERRY" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>

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

"Bob Phillips" wrote:

> =IF(AND(E9>=100,E9<=200), True,False)
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "CRICKETERRY" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>