Ignoring empty cells

  • Thread starter Thread starter Amnon Wilensky
  • Start date Start date
A

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
 
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
 
I'm not really sure what you mean, but try these:

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


Regards,
Ryan---
 
Thanks,
Teethless mama gave me the answer,
Amnon
ryguy7272 said:
I'm not really sure what you mean, but try these:

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


Regards,
Ryan---
Click to expand...
 
Back
Top