Thread: Formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob[_13_] Bob[_13_] is offline
external usenet poster
 
Posts: 32
Default 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.