increase all values in a column by a percentage

[Guest]

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

 

[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

 

[Fredrik Wahlgren]

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

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

 

[Guest]

Neik , fredrik , a million thanks guys , works perfect