Thread: Complex If
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PAL PAL is offline
external usenet poster
  
Posts: 200
Default Complex If
Any ideas where I went wrong here. Can't leave the cell

=IF(AND(U2="YES",OR(E2="Not-applicable",E2="Red"),"Yes",""))
Reply With QuoteReply With Quote