Thread: IF/AND worksheet function
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Fan924 Fan924 is offline
external usenet poster
  
Posts: 238
Default IF/AND worksheet function
Thanks, works great.
How about something more complex? I get an error with all I try

IF(AND(C10=C12,C10=C8),1,0) OR IF(AND(C10=C12,C10=C14),1,""),1,0)
returns a 1 of 0
Reply With QuoteReply With Quote