Check a range for a value

J

Jay

I have what seems a pretty straightforward question -

How, in *one* formula, can I check a range for a value?

i.e. Check whether any cell in the range A1:A9000 contains a zero,and
return 'Yes'.

Any help greatly appreciated......Jason
 
P

Pete_UK

Something like this will do it:

=IF(COUNTIF(A1:A9000,0)>0,"Yes","No")

and will not count blanks as equivalent to zero.

Hope this helps.

Pete
 
J

Jay

Thanks Pete, I figured that exact solution about 10 minutes after
posting!

I've been doing such complex excel work recently that I seemed to have
forgot that there are simple solutions to things :)

Thanks anyway.....Regards, Jason
 
Top