Stop zero on cell


A

Amnon Wilensky

Hi,
How can I stop Excel formula to consider a blank cell as a zero?
I have a column with zeros and blank cells. I need the formula to consider
the cells with zero as a condition to built the results but excel consider
the blanks cell as zero also.
Any help?

Using Excel 2003.

Thanks,

Amnon
 
Ad

Advertisements

G

Gary''s Student

It depends on your formula. For example. AVERAGE() is already clever enough
to ignore blanks, but include zeros. Post a simple example and we will show
you how.
 
D

David Biddulph

=IF(A2="","Result for blank",IF(A2=0,"Result for zero","Result for
non-zero"))
or if you want the same result for blank as for non-zero, then try
=IF(AND(A2<>"",A2=0),"Result for zero","Result for blank or non-zero")
 
A

Amnon Wilensky

Thanks,
Amnon
David Biddulph said:
=IF(A2="","Result for blank",IF(A2=0,"Result for zero","Result for
non-zero"))
or if you want the same result for blank as for non-zero, then try
=IF(AND(A2<>"",A2=0),"Result for zero","Result for blank or non-zero")
 
Ad

Advertisements

A

Amnon Wilensky

Thanks,
Amnon
Gary''s Student said:
It depends on your formula. For example. AVERAGE() is already clever
enough
to ignore blanks, but include zeros. Post a simple example and we will
show
you how.
 

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

Top