Thread: If function with some "And" plus an "Or" criteria
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andy Andy is offline
external usenet poster
  
Posts: 414
Default If function with some "And" plus an "Or" criteria
Is this possible to do? I know how to do an If with AND:

IF(AND(criteria1,criteria2),True,False)

and I can do an OR:

IF(OR(criteria1,criteria2),True,False)

but can I do both? Thanks for any help.
Reply With QuoteReply With Quote