Blamk cells and 0 values

G

gtm16

Hi,

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

regards
Gavin
 
S

Stefi

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

Regards,
Stefi

„gtm16†ezt írta:
 
M

Mike H

Hi

=ISBLANK(A1)

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

Mike
 
G

Gary''s Student

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

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
 
Top