Formula
 

I have a column of values and I want to show a given percentage increase in
the next column. I am sure I have seen somewhere that I can put the
percentage in an empy cell at the bottom of the worksheet and using a formula
these increases will be shown down the next column. I think I saw it in a
training session but can't be sure.

Formula
 

If your original figures are in column A, and your percentage increase is in
B100, then in B2 use the formula =A2*(1+B$100) for the increased value, and
copy down the column
--
David Biddulph

"Chris" wrote in message
...
I have a column of values and I want to show a given percentage increase in
the next column. I am sure I have seen somewhere that I can put the
percentage in an empy cell at the bottom of the worksheet and using a
formula
these increases will be shown down the next column. I think I saw it in a
training session but can't be sure.

Formula
 

This works for me. It's entered at the bottom of the second column of values
then dragged across as many columns as necessary. The row is labeled Percent
Change.

=(C17-B17)/B17



"Chris" wrote in message
...
I have a column of values and I want to show a given percentage increase in
the next column. I am sure I have seen somewhere that I can put the
percentage in an empy cell at the bottom of the worksheet and using a
formula
these increases will be shown down the next column. I think I saw it in a
training session but can't be sure.

Formula
 

This works for me. It's entered at the bottom of the second column of values
then dragged across as many columns as necessary. The row is labeled Percent
Change.

=(C17-B17)/B17



"Chris" wrote in message
...
I have a column of values and I want to show a given percentage increase in
the next column. I am sure I have seen somewhere that I can put the
percentage in an empy cell at the bottom of the worksheet and using a
formula
these increases will be shown down the next column. I think I saw it in a
training session but can't be sure.