How to distinguish zeros ("0") from blank cells?
 

I'm trying to figure out a way to get my formulas to distinguish cells with
no data from those that have a "0". Any ideas?

How to distinguish zeros ("0") from blank cells?
 

=LEN(A1)=0

returns TRUE for empty cell and FALSE for 0

=A1=""


returns TRUE for empty cells and FALSE for 0


--


Regards,


Peo Sjoblom


"Clay888" wrote in message
...
I'm trying to figure out a way to get my formulas to distinguish cells
with
no data from those that have a "0". Any ideas?

How to distinguish zeros ("0") from blank cells?
 

certain functions like AVERAGE will ignore blanks.

If you tell us specifically what you are trying to do, we can help you
figure it out.

"Clay888" wrote:

I'm trying to figure out a way to get my formulas to distinguish cells with
no data from those that have a "0". Any ideas?

How to distinguish zeros ("0") from blank cells?
 

"Peo Sjoblom" wrote...
=LEN(A1)=0

returns TRUE for empty cell and FALSE for 0

=A1=""

returns TRUE for empty cells and FALSE for 0
....

Both formulas also return TRUE for nonblank cells that evaluate to "".
ISBLANK(x) and COUNT(x)=0 provide stricter tests for whether a cell
contains nothing.