Thread: Nested IF AND OR statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Colin Hayes Colin Hayes is offline
external usenet poster
  
Posts: 465
Default Nested IF AND OR statement


Hi All

I need some help with a complicated formula.

I'm trying to say ;

IF E2 contains "A" , OR "B" , OR "C" , AND K2="D" then put "YES". IF not
put B1

Grateful for any help.


Reply With QuoteReply With Quote