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

"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

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

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