PDA

View Full Version : Finding a number in a range



Tenspeed39355
03-21-2006, 08:24 AM
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
03-21-2006, 09:38 AM
Try
=if(countif(C1:G1,B1)>0,"Yes","No")

HTH
Cal