Excel How to use the Excel IF function

[Higira]

Im trying to have the if function say that F20 and G20 is blank AND H20 has an X then this box = Yes
i cant for the life of me figure this out. help pls

thanks

 

[Higira]

closest i got is this
=CONCATENATE(IF(F20="N",IF(G20="N", IF(H20="x", "Yes ", "No"))))

F20: N G20:N H20:X = Yes
but if it say
F20:X G20:X H20:X = FALSE -- i want it to say No
F20:N G20:X H20:X = FALSE
F20:X G20:N H20:X = FALSE

to clarify i want it to say F20 N G20 N H20 X = Yes otherwise NO.

 

[Ian]

Are you saying that you only want the cell to say "Yes" only when F20 and G20 are empty and H20 = "X"? Under any other condition it'll be "No"?

If so, try this:

=IF(F20="",IF(G20="",IF(H20="x","Yes","No"),"No"),"No")

 

[Higira]

thank you! it works perfectly

 

[Ian]

My pleasure - glad it worked .