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

how can i ignore blank cells when multiple cells?
 

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

how can i ignore blank cells when multiple cells?
 

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

how can i ignore blank cells when multiple cells?
 

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

=PRODUCT(A1:D1)

hth RES

how can i ignore blank cells when multiple cells?
 

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