Check a range for a value

  • Thread starter Thread starter Jay
  • Start date Start date
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
 
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
 
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
 
Back
Top