View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
BluesMan BluesMan is offline
external usenet poster
 
Posts: 4
Default Possible to change/update values in range of cells by X% ?

Jim,

I got it to work except It only updated my prices by 10% using 1.1 in a
blank cell. I couldn't figure out what number to use to get 15% increase in
prices. I could really use your help.
Lee

"smartin" wrote:

Bluesman wrote:
Jim,

I have the exact same task as Tom. The only difference is that I need to
change column totals by 15%. I tried to follow along with the example you
gave Tom but unfortunately I don't have the multiplication option in the
"paste special" I am using excel 2003.

Help!!!!
Lee


Are you sure? This has been around since before E2003. In the Paste
Special dialog, "Multiply" is in the 2nd section labeled "Operation".