Excel How to use the Excel IF function

H

Higira

Joined
Aug 21, 2017
Messages
3
Reaction score
1
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
 
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.
 
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")
 
Back
Top