Stop zero on cell

  • Thread starter Thread starter Amnon Wilensky
  • Start date Start date
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
 
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.
 
=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")
 
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")
Click to expand...
 
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.
Click to expand...
 

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

How to count the maximum number flanked by zeros 9
Blank Cells vs. Zero Values 2
Adding recognised Zeros 5
Counting blanks as zeros 1
Zero and Null Sum Function 2
Ignoring empty cells 6
Zero if zero yet blank if blank? 5
Zero and Empty cells, What to do 7

Back
Top