IF condition doubt

0

The value in A1 cell is "NA"

B1 cell contains a formula. i.e. =if(A1>=20,"YES","NO")

I expect result in B1 is NO, since condition test is FALSE. But actually it shows result YES.

Please clarify my doubt

Answer
Discuss

Discussion

Please don't forget to select the answer that worked best for you! Just click the Select Answer button at the bottom of the desired answer.
don (rep: 1247) Jul 13, '17 at 2:32 pm
Add to Discussion

Answers

1

Your test does not include if there is a TEXT or N/A value which you would need to consider.  Try the formula: =IF(AND(ISNUMBER(A1),A1>=20),"Y"," NO")        or try: =IF(ISNA(A1),"NotNumeric",IF(A1>=20,"YES","NO")).

  Let me know if this helped/answered question.  Thank you

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login