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

=AND(A1118,A1<121)

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

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

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

--
Rick (MVP - Excel)


"M.A.Tyler" <Great Lakes State wrote in message
...
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