Stop zero on cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amnon Wilensky - 07 Feb 2008 17:48 GMT

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

Reply to this Message

Gary''s Student - 07 Feb 2008 17:58 GMT

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.

Signature

Gary''s Student - gsnu2007d

> Hi,
> How can I stop Excel formula to consider a blank cell as a zero?
[quoted text clipped - 8 lines]
>
> Amnon

Reply to this Message

Amnon Wilensky - 08 Mar 2008 08:03 GMT

Thanks,
Amnon

> It depends on your formula. For example. AVERAGE() is already clever
> enough
[quoted text clipped - 16 lines]
>>
>> Amnon

Reply to this Message

David Biddulph - 07 Feb 2008 18:03 GMT

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

Signature

David Biddulph

> Hi,
> How can I stop Excel formula to consider a blank cell as a zero?
[quoted text clipped - 8 lines]
>
> Amnon

Reply to this Message

Amnon Wilensky - 08 Mar 2008 08:02 GMT

Thanks,
Amnon

> =IF(A2="","Result for blank",IF(A2=0,"Result for zero","Result for
> non-zero"))
[quoted text clipped - 12 lines]
>>
>> Amnon

Reply to this Message

Gord Dibben - 07 Feb 2008 18:22 GMT

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

Gord Dibben MS Excel MVP

>Hi,
>How can I stop Excel formula to consider a blank cell as a zero?
[quoted text clipped - 8 lines]
>
>Amnon

Reply to this Message

Amnon Wilensky - 08 Mar 2008 08:02 GMT

Thanks,
Amnon

> =IF(A1="","",A1)
>
[quoted text clipped - 12 lines]
>>
>>Amnon

Reply to this Message