| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
