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.
--
Gary''s Student - gsnu2007d


"Amnon Wilensky" wrote:

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