Thread: How do I make this formula work =if(a1=(b10:b20),"good","bad").
View Single Post
  #2   Report Post  
tjtjjtjt
 
Posts: n/a
Default
AK,

This should do it:
=IF(COUNTIF(B1:B10,A1)0,"good","bad")

tj

"AK" wrote:

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