Thank you very much .
I use this formula you and David Biddulph suggested and it works.
Thank you again.
regarding Shaun Scovil's formula , i will work on it and let you know the
result.
best wishes
M.Rafat


"Stan Brown" wrote:

Thu, 12 Apr 2007 12:00:02 -0700 from M.Rafat
:
there is no conditions , but I wish to use one of C1 or D1 cell to be
multiplied by B1.
actually , one of C1 or D1 has 0 ( zero ) value and the other has number (
value ) .

If either C1 or D1 is zero, and you want to multiply by the nonzero
one, then multiply by (C1+D1).

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/