If(AND formula help please
Try this
=IF(AND(A1<=-20,A1=-30),"falls20-30","")
-20 is bigger than -30 and we tend to forget that....
If this post helps click Yes
---------------
Jacob Skaria
"ferde" wrote:
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","")
|