Add 5% to an existing formula

[craigb1979]

Hi

Have this formula:

=(K12+V12)*F12

K12 is a product cost
V12 is a ancillary product cost
F12 is the exchange rate from $ to £

I want to add a 5% currency fluctuation surcharge into the calculation , I have 5% written in cell G12

Is there a way I can add to the formula the 5% to the 2 products cost after the currency conversion ?

 

[Special-K99]

If you change K12 and V12 that will affect the formula.

Are you saying you want to change the K12 and V12 values without affecting the formula?

 

[James006]

Hi,

What about

=(K12+V12)*F12*(1+G12)

Hope this will help

 

[CharlesChuckieCharles]

=(k12+v12)*f12*(100%+g12)

 

[craigb1979]

Thank you everyone, problem solved

 

[James006]

Glad you could fix your problem ... :wink: