Using IF in an array
 

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.

Using IF in an array
 

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.