Cell for Changing Multiple Values in other columns
 

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

Cell for Changing Multiple Values in other columns
 

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" wrote:

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

Cell for Changing Multiple Values in other columns
 

Thanks.


"Mike H" wrote:

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" wrote:

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

Cell for Changing Multiple Values in other columns
 

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) ?
--
David Biddulph

"Mike H" wrote in message
...
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" wrote:

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