Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If(AND formula help please
Can someone help me with a formula.
if A1 is between -20 to -30 the result is "falls20-30" otherwise leave blank. I am using the the following formula with no success. =IF(AND(A1=-20,A1=-30),"falls20-30","") |