=IF(COUNTIF(F2:F8),1)0,1,0)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Iain - T" <Iain - wrote in message
...
I want to check if a known number appears in a column of cells. If it
does
then I want a "1" to appear if not then I want a "0" to appear.

In cell F23 I have used =IF(F2:F8="1",1,0) and =IF(F2:F8=D23,1,0), where
cells F2 to F8 contain various numbers to be checked against the number
"1"
or the value of D23 (which in this case equals 1.)

All I get is a #VALUE in the

I would then check F2 to F8 against D24 (=2) or the number 2

I think the answer may be simple, but I just cannot see it