how can i ignore blank cells when multiple cells?

A

arash

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
 
M

MDBCT

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

Robert_Steel

Have a look at the PRODUCT function
this will ignore empty and text cells

=PRODUCT(A1:D1)

hth RES
 
Top