Hi Bill;

I considered 'Countif' but in the case that the value appears twice the
function will return a '2'. I want the function to only return only
TRUE/FALSE or 0/1 regardless of how many times the value appears.

....C_Guy

"Bill Kuunders" wrote:


=COUNTIF(A3:F7,A8)

--
Greetings from New Zealand
Bill K
"C_Guy" wrote in message
...
Hello everyone;

I need some help with the Excel 'if' function. I have a lot of data I
need
to analyze. I want to write an IF statement that will check if the value
of
a particular cell is found within a range of other cells. I need to
reference the cell in the function (not the actual value) because I will
be
copying the formula all over my worksheet.

For example, I want to see if the value in cell A8 is found anywhere in
cells A3:F7. The best I could come up with is:

=IF(A8=A3:F7,1,0)

The result was #VALUE!
The value in A8 does in fact appear within the range A3:F7.

What am I doing wrong?

Thanks!


...C_Guy