Using IF in an array

  • Thread starter Thread starter L Martin
  • Start date Start date
L

L Martin

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Learning arrays. 13
Mapping integers to strings 5
SUMPRODUCT to substiute array formula 7
Array formula lock-up 1
search array 3
INDEX & MATCH find first column value in an array? 3
Display an array of references 1

Back
Top