Blamk cells and 0 values

  • Thread starter Thread starter gtm16
  • Start date Start date
G

gtm16

Hi,

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

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

Regards,
Stefi

„gtm16†ezt írta:
 
Hi

=ISBLANK(A1)

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

Mike
 
You are welcome! Thanks for the feedback!
Stefi

„gtm16†ezt írta:
 
Some functions treat them differently. AVERAGE ignores blanks but recognizes
zeros.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
If function across sheets prints value of cell 4
#value error for sumproduct using RIGHT cmd 0
Conditional Formatting 1
Excel VBA 1
Excel Need Countifs Formula Help 0
IF Function -- Return Null Value Help 2
calculate average from non contiguous column, ignoring (0) values 3

Back
Top