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
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
IF condition doubt
0
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: 1989) Jul 13, '17 at 2:32 pm
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