Finding a number in a range

[Tenspeed39355]

Good moring guys I am trying to find a number in a range of numbers that
is equal to a number in B1. I am using the following formula
=IF(C1:G1=B1,"Yes","No") I keep getting an error message. I have tried changing the formula with no luck. If I change the formula to read
=IF(C1=B1,"Yes","No") that works. What am I doing wrong with the first
formula? Thanks for any help
Max

[CBrine]

Try
=if(countif(C1:G1,B1)>0,"Yes","No")

HTH
Cal