Hi All,

I am trying to work out the formula to do the following (attached example)

Multiply B*C*E OR if there is a number in D then formula should be B*D*E

the other issue is that I would like it to presume B is 1 unless another number is typed in.


I thank all you 'clever folk' for your assistance.
I know these things are probably pretty mundane for people with your skills, withthe thing I am working on just know I can promise I will be back on with some tricker issues in the coming days -with a big job, and a serious deadline.

Thank in advanceFormula. Multiply A by C or A by D if there is a number in D. Q Muliply all by B - PRESUME B to.xlsx