On Apr 12, 3:00 pm, M.Rafat wrote:
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 ) .
is it enough or I may send the snapshot of what I am looking for ?
Thanks in advance.
M.Rafat



"Michael Behm" wrote:
How do you decide if you want it multiplied by C1 or D1? What are the
conditions?

"M.Rafat" wrote in message
...
Need help for creating a formula.
I need a formula to do the folowing on Excel 2003 program :
B1 cell x ( C1 and or D1 ) and put the figure on E1
in other words :
multiply B1 to either C1 and or D1 and put the calculated figure on E1.
Thanks in advance.
best wishes
M.Rafat- Hide quoted text -

- Show quoted text -


Enter this formula into E1:

=IF(C1=0,B1*D1,B1*C1)

-Shaun Scovil