Ignoring empty cells

[Amnon Wilensky]

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

 

[Tyro]

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

 

[Teethless mama]

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

 

[ryguy7272]

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

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


Regards,
Ryan---

 

[Amnon Wilensky]

Thanks Tyro,
Toothless Mama gave my the answer,
Amnon

 

[Amnon Wilensky]

Thanks,
Amnon

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

 

[Amnon Wilensky]

Thanks,
Teethless mama gave me the answer,
Amnon

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

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


Regards,
Ryan---