range equal zero then "x"

J

jzachar

If I wanted to check to see if all cells in a range are blank how would I do
that. I want to put an "x" in the formula cell if all cells in the range are
zero.

thank you very much!
Jeff
 
P

Peo Sjoblom

=IF(COUNTBLANK(Range)=ROWS(Range),"x","not blank")

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 
R

Ron Coderre

Try something like this:

To check if all cells in A1:A10 are blank, try this:

B1: =IF(COUNTA(A1:A10),"not all blank","X")

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP
 
R

Ron Coderre

OOPS! I just noticed that you want to count a zero value as a blank.

COUNTA values zeros, apostrophes, and dbl-quotes as non-blank.
COUNTBLANK, as per Peo's post, performs as you requested,.

***********
Regards,
Ron

XL2002, WinXP
 
Top