IF Statement
 

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?

IF Statement
 

Try this:

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


--
Biff
Microsoft Excel MVP


"KC_Cheer_Coach" wrote in message
...
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?

IF Statement
 

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


"KC_Cheer_Coach" wrote in message
...
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?

IF Statement
 

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!



"Bob Umlas" wrote:

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


"KC_Cheer_Coach" wrote in message
...
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?

IF Statement
 

This worked when I replaced the commas with pipes

I've never seen | used as argument separators!

--
Biff
Microsoft Excel MVP


"KC_Cheer_Coach" wrote in message
...
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!



"Bob Umlas" wrote:

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


"KC_Cheer_Coach" wrote in
message
...
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?