more than, but less than

[M.A.Tyler]

I need a formula that will determine if the number in A1 is between 118 and
121. Preferably an if statement.

Regards,

M.A.Tyler

 

[Rick Rothstein]

Well, if all you want is TRUE or FALSE, you can use this...

=AND(A1>118,A1<121)

but if you want a different report, then this...

=IF(AND(A1>118,A1<121),"Yes","No")

Changing the "Yes" and "No" according to your needs.

 

[M.A.Tyler]

Thanks Rick.

Well, if all you want is TRUE or FALSE, you can use this...

=AND(A1>118,A1<121)

but if you want a different report, then this...

=IF(AND(A1>118,A1<121),"Yes","No")

Changing the "Yes" and "No" according to your needs.