how can i ignore blank cells when multiple cells?

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(D1="",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>.

Robert_Steel@nothanks.com wrote:
>
> Have a look at the PRODUCT function
> this will ignore empty and text cells
>
> =PRODUCT(A1:D1)
>
> hth RES

--

Dave Peterson