Hi!

Try this:

=IF(COUNTIF(A1:A10,"xx"),"your_message_here","")

Replace xx with the certain entry.

If the certain entry is a TEXT string enclose it in quotes like above. If
the certain entry is a NUMERIC value do not enclose it in quotes.

Biff

"L Martin" wrote in message
...
Would like to use the IF worksheet function to scan a column to determine
if any of the cells contain a certain entry and if so, to display a
message. Excel Help mentions that this can be done, but does not give any
details on how to do it.
Thanks for any help.