Formula

[Chris]

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.

 

[David Biddulph]

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

 

[Bob]

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

 

[Bob]

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