more than, but less than

M

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
 
R

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

M.A.Tyler

Thanks Rick.

Rick Rothstein said:
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.
Click to expand...
 
Top