Thread: Too Many If's
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rianne Rianne is offline
external usenet poster
 
Posts: 7
Default Too Many If's

Many instances, but will only return the caution once.

A B C D
1 * *
2 * *
3 * * * *
4 *
5 * *

"Toppers" wrote:

Try this if just want a message to say you have found (at least) one (*) in
the range:

=IF(SUMPRODUCT(--(ISNUMBER(FIND("*",A1:B10)))),"hey, found","")

HTH


"Rianne" wrote:

I'm trying to write a formula that will locate an asterisk (*) in a large
range of data, and if it is found, put a statement like "Hey, I found an
asterisk!" in one cell. I can't seem to get my head around the formula, asn
I've only been able to replicate what I want by using multiple IF statements.
I have over 200 cells that could have the asterisk in it. Please help, it
would be greatly appreciated.