Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 9th 05, 07:41 PM
BayComp
 
Posts: n/a
Default 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   Report Post  
Old April 9th 05, 08:07 PM
Niek Otten
 
Posts: n/a
Default

In an empty cell, enter =1+YourPercentage, (like =1+4%)
EditCopy
Select your data
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   Report Post  
Old April 9th 05, 08:30 PM
Fredrik Wahlgren
 
Posts: n/a
Default


"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   Report Post  
Old April 10th 05, 12:59 PM
BayComp
 
Posts: n/a
Default

Neik , fredrik , a million thanks guys , works perfect



"Niek Otten" wrote:

In an empty cell, enter =1+YourPercentage, (like =1+4%)
EditCopy
Select your data
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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Column Chart with 2 values in each column Alec Green Charts and Charting in Excel 2 February 25th 05 06:12 AM
Formula to compare multiple rows values based on another column? Murph Excel Worksheet Functions 4 February 21st 05 02:44 AM
How sum values in column B using values in column A as the conditi oldgrayelf Excel Worksheet Functions 5 February 4th 05 09:03 PM
Removing duplicate values in a column natan Excel Worksheet Functions 2 November 22nd 04 06:48 AM
Can you average data in 1 column based on a range of values in another? kman24 Excel Worksheet Functions 2 November 17th 04 02:09 PM


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

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017