IF Statement

[KC_Cheer_Coach]

I am creating a spreadsheet with several conditional formulas. They all work
except for one. I need the following:

IF S4 = YES and T4 = YES then W4 = YES else NO
OR
IF U4 = YES then W4 = YES else NO

I can get this part to work:
=IF(AND($S4="YES"|$T4="YES")|"YES"|"NO")
But I cannot put the OR in there.

Can you help?

 

[T. Valko]

Try this:

=IF(OR(U4="Yes",AND(S4="Yes",T4="Yes")),"Yes","No")

 

[Bob Umlas]

=IF(OR(AND(S4="YES","T4="YES"),U4="YES"),"YES","NO")

 

[KC_Cheer_Coach]

This worked when I replaced the commas with pipes and took the extra
quotation out from in front of T4. Thank you sooooo much. It was driving me
bonkers!

 

[T. Valko]

This worked when I replaced the commas with pipes

I've never seen | used as argument separators!