Ignoring empty cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amnon Wilensky - 06 Mar 2008 15:50 GMT

Hi,
how can I force excel 2003 to ignore in calculation empty cells but not
cells with zero.

For example:
the formula =If(d4=0,e4*f4," ")
brings 600000 in the first cell and 120000 in the second cell even so the
cell is empty.

600000 0 500 1200
120000 300 400

Any help?

Thanks,
Amnon

Reply to this Message

Tyro - 06 Mar 2008 16:01 GMT

What cell contains 0? What cell contains 500? What cell contains 1200? What
cell contains 300? What cell contains 400?
I presume the 600000 is the result of your formula as is the 120000.

Tyro

> Hi,
> how can I force excel 2003 to ignore in calculation empty cells but not
[quoted text clipped - 12 lines]
> Thanks,
> Amnon

Reply to this Message

Amnon Wilensky - 06 Mar 2008 16:49 GMT

Thanks Tyro,
Toothless Mama gave my the answer,
Amnon

> What cell contains 0? What cell contains 500? What cell contains 1200?
> What cell contains 300? What cell contains 400?
[quoted text clipped - 18 lines]
>> Thanks,
>> Amnon

Reply to this Message

Teethless mama - 06 Mar 2008 16:06 GMT

=IF(D4<>"",E4*F4,"")

> Hi,
> how can I force excel 2003 to ignore in calculation empty cells but not
[quoted text clipped - 12 lines]
> Thanks,
> Amnon

Reply to this Message

Amnon Wilensky - 06 Mar 2008 16:49 GMT

Thanks,
Amnon

> =IF(D4<>"",E4*F4,"")
>
[quoted text clipped - 14 lines]
>> Thanks,
>> Amnon

Reply to this Message

ryguy7272 - 06 Mar 2008 16:06 GMT

I'm not really sure what you mean, but try these:

=If(d4=0,e4*f4,"")
=If(d4=0,e4*f4,0)

Regards,
Ryan---

Signature

RyGuy

> Hi,
> how can I force excel 2003 to ignore in calculation empty cells but not
[quoted text clipped - 12 lines]
> Thanks,
> Amnon

Reply to this Message

Amnon Wilensky - 06 Mar 2008 16:50 GMT

Thanks,
Teethless mama gave me the answer,
Amnon

> I'm not really sure what you mean, but try these:
>
[quoted text clipped - 20 lines]
>> Thanks,
>> Amnon

Reply to this Message