EXCEL replace "False" with "NO"

I am trying to print the word NO on the input if the condition is false. Here is what I am trying to do now

=IF (A2="a")AND(b2="b", "YES","NO")


This seems to work, but I keep getting this error | Formula parse error.

I am new to EXCEL and I have no idea what am I doing wrong? Any help would be great Thanks!


source to share

3 answers

Use If()

and AND

like this:



Pay close attention to the closure )

in And()

, I got frustrated several times forgetting about it and wondering why my If

formula didn't work.



You were close. try it





Format a cell with a custom format



Then convert the cell formula result to an integer.





All Articles