Thread
:
If(AND formula help please
View Single Post
#
1
Posted to microsoft.public.excel.misc
ferde
external usenet poster
Posts: 87
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","")
Reply With Quote
ferde
View Public Profile
Find all posts by ferde