Thread: if,and or functions
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default if,and or functions
=IF(AND(A1=1,OR(B1={2,3,4,5,6})),1,0)
--
David Biddulph

"cp" wrote in message
...
Could someone please help

I like to write a formula

If Cell A =1, and Cell B= 2,3,4,5,or 6, then give me a result of 1,
otherwise 0

Thanks


Reply With QuoteReply With Quote