Blamk cells and 0 values
 

Hi,

Can anyone tell me how to differentiate between blank cells and cells
with a 0 value?

regards
Gavin

Blamk cells and 0 values
 

=ISNUMBER(A1)
returns False for blank
True for 0

Regards,
Stefi

€žgtm16€� ezt Ã*rta:

Hi,

Can anyone tell me how to differentiate between blank cells and cells
with a 0 value?

regards
Gavin

Blamk cells and 0 values
 

Hi

=ISBLANK(A1)

Returns TRUE for a blank cell and FALSE for an empty string or zero

Mike

"gtm16" wrote:

Hi,

Can anyone tell me how to differentiate between blank cells and cells
with a 0 value?

regards
Gavin

Blamk cells and 0 values
 

On Dec 12, 9:24 am, Stefi wrote:
=ISNUMBER(A1)
returns False for blank
True for 0

Regards,
Stefi

„gtm16" ezt írta:



Hi,

Can anyone tell me how to differentiate between blank cells and cells
with a 0 value?

regards
Gavin- Hide quoted text -

- Show quoted text -

Thanks

Blamk cells and 0 values
 

You are welcome! Thanks for the feedback!
Stefi

€žgtm16€� ezt Ã*rta:

On Dec 12, 9:24 am, Stefi wrote:
=ISNUMBER(A1)
returns False for blank
True for 0

Regards,
Stefi

€žgtm16" ezt Ã*rta:



Hi,

Can anyone tell me how to differentiate between blank cells and cells
with a 0 value?

regards
Gavin- Hide quoted text -

- Show quoted text -

Thanks

Blamk cells and 0 values
 

Some functions treat them differently. AVERAGE ignores blanks but recognizes
zeros.
--
Gary''s Student - gsnu2007b


"gtm16" wrote:

Hi,

Can anyone tell me how to differentiate between blank cells and cells
with a 0 value?

regards
Gavin

Blamk cells and 0 values
 

A blank cell is like Saddam Hussein.
A cell with zero is like George Bush.

not much dif
Ok, not on topic, so ..... neither XL.

"gtm16" wrote in message ...
Hi,

Can anyone tell me how to differentiate between blank cells and cells
with a 0 value?

regards
Gavin