Remember Me?

#1
April 9th 05, 07:41 PM
 BayComp Posts: n/a
increase all values in a column by a percentage

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

#2
April 9th 05, 08:07 PM
 Niek Otten Posts: n/a

In an empty cell, enter =1+YourPercentage, (like =1+4%)
EditCopy
EditPaste Special, Check Multiply

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"BayComp" wrote in message
...
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

#3
April 9th 05, 08:30 PM
 Fredrik Wahlgren Posts: n/a

"BayComp" wrote in message
...
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

#4
April 10th 05, 12:59 PM
 BayComp Posts: n/a

Neik , fredrik , a million thanks guys , works perfect

"Niek Otten" wrote:

In an empty cell, enter =1+YourPercentage, (like =1+4%)
EditCopy
EditPaste Special, Check Multiply

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"BayComp" wrote in message
...
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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Alec Green Charts and Charting in Excel 2 February 25th 05 06:12 AM Murph Excel Worksheet Functions 4 February 21st 05 02:44 AM oldgrayelf Excel Worksheet Functions 5 February 4th 05 09:03 PM natan Excel Worksheet Functions 2 November 22nd 04 06:48 AM kman24 Excel Worksheet Functions 2 November 17th 04 02:09 PM

All times are GMT +1. The time now is 01:35 AM.