What's the best way to increase a whole series of numbers by the same
percentage? Usually all in one column. Thank you.

Hi,

Let's say you want to increase the values in A1:A100 by 25%. In a blank cell
type 1.25 and copy that cell, next select A1:A100 and do a Paste Special -
Multiply.

HTH
Jean-Guy

"jonilyn" wrote:

What's the best way to increase a whole series of numbers by the same
percentage? Usually all in one column. Thank you.

To increase with 5%:
In an empty cell, enter the number 1.05 (for 6%: enter 1.06 etc)
EditCopy
Select the numbers to increase
EditPaste Special, check Multiply

Test first on a copy of your workbook!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"jonilyn" wrote in message ...
| What's the best way to increase a whole series of numbers by the same
| percentage? Usually all in one column. Thank you.

In an empty cell enter -say - 1.03 and copy the cell, ( to increase the data
by 3%

Highlight the data you want to increase and then right-click and select
Paste Special Multiply

All highlighted cells will be increased by 3%

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"jonilyn" wrote in message
...
What's the best way to increase a whole series of numbers by the same
percentage? Usually all in one column. Thank you.

Put =(1+x%) in a spare cell, copy, select your column, edit/ paste special/
multiply.
--
David Biddulph

"jonilyn" wrote in message
...
What's the best way to increase a whole series of numbers by the same
percentage? Usually all in one column. Thank you.

Assume you want to increase the range of numbers in A1:A10 by 10%

Enter 1.1 in cell B1
Copy cell B1
EditCopy
Then select the range A1:A10
Then do EditPaste SpecialMultiplyOK
Clear cell B1

Biff

"jonilyn" wrote in message
...
What's the best way to increase a whole series of numbers by the same
percentage? Usually all in one column. Thank you.