Blamk cells and 0 values

[gtm16]

Hi,

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

regards
Gavin

 

[Stefi]

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

Regards,
Stefi

„gtm16†ezt írta:

 

[Mike H]

Hi

=ISBLANK(A1)

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

Mike

 

[gtm16]

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

Regards,
Stefi

„gtm16" ezt írta:






- Show quoted text -

Thanks

 

[Stefi]

You are welcome! Thanks for the feedback!
Stefi

„gtm16†ezt írta:

 

[Gary''s Student]

Some functions treat them differently. AVERAGE ignores blanks but recognizes
zeros.

 

[Robert McCurdy]

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.

Hi,

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

regards
Gavin