If function

[ryan12345]

Basically in a cell e.g. 'C2' I want an If statement to see if a number of cells e.g. B2,B3,B4,B5,B6,B7,B8 are not equal to a certain cell e.g. C4 and if none of them are equal to the value in 'C4' then I want it to say "No'" and if at least one does then for it to say "Yes". Any suggestions?

[Andrew-R]

In C2 try:

=IF(ISNA(MATCH(C4,B2:B8,0)),"No","Yes")

[ryan12345]

I've done this =IF((COUNTIF(B2:B8,C4 )) = 0, "Yes", "No")

So if none of them equal C4 then the answer will be 0 and so "Yes" is displayed