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

Use:


=IF(A1="",1,A1)*IF(B1="",1,B1)*IF(C1="",1,C1)*IF(D 1="",1,D1)
--
Gary''s Student


"arash" wrote:

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.



"arash" wrote:

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

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

=PRODUCT(A1:D1)

hth RES

Ouch, my eyes <vbg.

wrote:

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

=PRODUCT(A1:D1)

hth RES

--

Dave Peterson