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

=IF(ISERROR(MATCH(A1,$B$10:$B$20,0)),"Bad","Good")

Rgds,
Andy


Reply With QuoteReply With Quote