formula?

[Guest]

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

 

[Guest]

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

 

[Niek Otten]

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

Test first on a copy of your workbook!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[David Biddulph]

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

 

[T. Valko]

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

Enter 1.1 in cell B1
Copy cell B1
Edit>Copy
Then select the range A1:A10
Then do Edit>Paste Special>Multiply>OK
Clear cell B1

Biff