more than, but less than
 

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

more than, but less than
 

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

more than, but less than
 

Thanks Rick.

"Rick Rothstein" wrote:

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