Thread: If function with some "And" plus an "Or" criteria
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default If function with some "And" plus an "Or" criteria
=IF(AND(criterion1,OR(criterion2,criterion3)),valu e_if_true,value_if_false)
or
=IF(OR(criterion1,AND(criterion2,criterion3)),valu e_if_true,value_if_false)
or nest the functions to suit your requirements.
--
David Biddulph

"Andy" wrote in message
...
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