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.
--
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

=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")
--
David Biddulph

"Amnon Wilensky" wrote in message
...
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

=IF(A1="","",A1)


Gord Dibben MS Excel MVP


On Thu, 7 Feb 2008 19:48:13 +0200, "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

Hi,

I have attached a sample with what I have done and you can see that when the
formula works on heading with empty cell the results are the same as the
cell contain zero. my sheet contains 348 rows with mixed data.

Thanks,

Amnon

"Amnon Wilensky" wrote in message
...
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

Thanks,
Amnon
"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=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")
--
David Biddulph

"Amnon Wilensky" wrote in message
...
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

Thanks,
Amnon
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
=IF(A1="","",A1)


Gord Dibben MS Excel MVP


On Thu, 7 Feb 2008 19:48:13 +0200, "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

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