Increasing values by 10 percent

bluecat · Jun 23rd 2004

Hi. I know this has gotta be one of easiest questions and I feel silly asking it, but how the heck do I increase a row (vertically) of say 100 cells by a percent? Say 10%. I'm simply trying to increase the value of prices in this row. :thanx:

KiwiSteve · Jun 23rd 2004

Hi bluecat

Put 1.1 in a cell.
Select that cell , right-click, then Copy
Select you 100 cells, rightclick, PasteSpecial
Check Multiply (in the middle section!)
OK

Cheers

Stephen

KiwiSteve · Jun 23rd 2004

Sorry, should have added:
1.1 = (100%+10%)
for 25% increase use 1.25, etc.
Decreasing by a % goes like this:
0.80 = (100%-20%), etc.

Cheers

KiwiSteve

bluecat · Jun 23rd 2004

Thank you very much for the quick reply, very appreciated.

shades · Jun 23rd 2004

The handy add-in, ASAP Utilities has this capability in one step, no extra columns needed. Plus it has ~299 other handy capabilities.

http://www.asap-utilities.com

bluecat · Jun 23rd 2004

Thank you, got it installed; appreciate it. :guitar:

Increasing values by 10 percent

Participate now!

Share