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.
|