Thread: How do I make this formula work =if(a1=(b10:b20),"good","bad").
View Single Post
  #1   Report Post  
AK
 
Posts: n/a
Default How do I make this formula work =if(a1=(b10:b20),"good","bad").
I need to check if the number in cell a1 equals one of the numbers in cells
b10 though b20.
Reply With QuoteReply With Quote