Stop zero on cell
Thanks,
Amnon
"Gary''s Student" wrote in message
...
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
|