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","") |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If(AND formula help please
Try this:
=IF(AND(A1<=-20,A1=-30),"Falls 20-30","") -- Biff Microsoft Excel MVP "ferde" wrote in message ... 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","") |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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","") |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If(AND formula help please
Please write this formula
=IF(AND(A1<=-20,A1=-30),"falls 20-30","") "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","") |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
If(AND formula help please
Thank you ...works great
"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","") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|