Ignoring empty cells


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
 
Ad

Advertisements

T

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
 
R

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

Advertisements

A

Amnon Wilensky

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top