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