how can i ignore blank cells when multiple cells?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

when i want multiple some celss like
a1*b1*c1*d1
maybe some of this cells are blank
and excel equal that to zero
how can i ignor the zero value (balnk cells ) in multiple

thx
 
No if statement are necessary to accomplish this.

=PRODUCT(A1:D1)

will work. It will only multiply all numbers that are in your range -
ignoring text too.
 
Have a look at the PRODUCT function
this will ignore empty and text cells

=PRODUCT(A1:D1)

hth RES
 

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

Similar Threads

Comparing Cells 2
How to set the value to zero if it negative after the substract 5
Ignore blanks in multiplication formula 4
Adding Cells, Get Error. 2
Excel Concatenate with line breaks but ignore blank cells 3
Blank Cells vs. Zero Values 2
Counting blanks as zeros 1
reffering another cell value which contains RAND() 0

Back
Top