Cell for Changing Multiple Values in other columns

  • Thread starter Thread starter Nadine
  • Start date Start date
N

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
 
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
 
Thanks.


Mike H said:
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
Click to expand...
 
Back
Top