Cell for Changing Multiple Values in other columns

[Nadine]

I did this years ago, but can remember how. Have several columns with
specific dollar amounts, and want to it set up so if I a cell that contains a
percentage rate for increase, and if I change this percentage all the dollar
amounts in the other columns will automatically increase by set percentage.

Thanks

 

[Mike H]

Nadine,

This is the best way to set up a worksheet where multiplication/division
factors are in a cell and there are a couple of ways and here's one.

Create a named range for (say) VAT and call it VAT and enter 17.5% you can
then have a formula along the line of

=A1+Vat

this will then add 17.5% to whatever is in a1. Change the vat constant to
15% and all the formula re-calculate automatically.

Mike

 

[Nadine]

Thanks.

Nadine,

This is the best way to set up a worksheet where multiplication/division
factors are in a cell and there are a couple of ways and here's one.

Create a named range for (say) VAT and call it VAT and enter 17.5% you can
then have a formula along the line of

=A1+Vat

this will then add 17.5% to whatever is in a1. Change the vat constant to
15% and all the formula re-calculate automatically.

Mike

 

[David Biddulph]

Are you sure that you intended that, Mike?
If you have £1000 in A1, your A1+VAT would give £1000.175, rather than
£1175.
Did you intend to say =A1*(1+VAT) ?