increase all values in a column by a percentage

B

BayComp

How di i change the value of all data in a column by a given percentage? e.g
i want to increase an entire columns entered values by a percentage i choose.


TIA
 
N

Niek Otten

In an empty cell, enter =1+YourPercentage, (like =1+4%)
Edit>Copy
Select your data
Edit>Paste Special, Check Multiply

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
F

Fredrik Wahlgren

BayComp said:
How di i change the value of all data in a column by a given percentage? e.g
i want to increase an entire columns entered values by a percentage i choose.


TIA
Click to expand...

Snipped from http://www.j-walk.com/ss/excel/usertips/tip059.htm


1.. Enter 1.05 (percentage) into any blank cell.
2.. Select the cell and choose Edit, Copy.
3.. Select the range of values and choose Edit, Paste Special.
4.. Choose the Multiply option and click OK.
5.. Delete the cell that contains the 1.05.
/Fredrik
 
Top