Thread: if,and or functions
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sebation.G[_2_] Sebation.G[_2_] is offline
external usenet poster
  
Posts: 37
Default if,and or functions
TRY:
=(A:A=1)*(B:B={2,3,4,5,6})*1

Hope this can be helpful

--
Regards,

Sebation.G
"cp" ...
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