Thread: IF Statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KC_Cheer_Coach KC_Cheer_Coach is offline
external usenet poster
 
Posts: 8
Default 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?