Very easy sum I can't work out!

[rickwardyy]

So In cell I3 I have a number, I need that number to times by 2 if cell I4 says 'Yes'.

Thanks in advance!

 

[steve the fish]

Is the number 2 typed into I3 or is it the result of a formula? If so what is the formula?

 

[rickwardyy]

No in I3 I have a number £200 which needs to time by two if the cell I4 contains 'Yes'.

 

[steve the fish]

Ok so is £200 the result of a formula? If so what is the formula?

 

[rickwardyy]

ADVERTISEMENT

I'm confused. In cell I7 I need a sum that will times cell I2 by two if cell I4 Contains a 'Yes'.

 

[CsJHUN]

If you want to change the 200 to 400 you need to use VBA, without it, i suggest if I5 is empty, or not used, use this formula: =If(I4="yes", 2xI3, I3) . As result, if there is "yes" in I4 the I3 value will be multiplied by 2, if not "yes" in I4, the original value will be shown.

 

[FDibbins]

I'm confused. In cell I7 I need a sum that will times cell I2 by two if cell I4 Contains a 'Yes'.

If that is what you want, then...
I7=I2*if(I4="yes",2,1)