Thread: Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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.