Hi Gary,

Thanks for your solution. I did have to reverse the true and the false in your formula because I was getting a false when the 9 is
present, but after I made that change, I liked it and it worked great.

Thanks again,

Richard
--
RMC,CPA


"Gary L Brown" wrote in message ...
Assuming your range of cells is A1:B5...

=IF(SUMPRODUCT(LEN(A1:B5)-LEN(SUBSTITUTE(A1:B5,"9","")))<0,FALSE,TRUE)

HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"R. Choate" wrote:

I need to try to cobble together a function nest or whatever I have to do, which will tell me if the number 9 exists anywhere
within
a range of cells. The 9 could be just one character of a larger number (i.e. 1496), or it could be just a nine. I know that I
could
use filtering or use the find feature with the dialog box, but I need a formula instead. Also, I just need to know a true or
false;
I don't need to know where the nine is or any other info. I just need to know if it is there. I'm stumped. Any ideas?

Thanks in advance!
--
RMC,CPA