A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

increase all values in a column by a percentage



 
 
Thread Tools Display Modes
  #1  
Old April 9th 05, 07:41 PM
BayComp
external usenet poster
 
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
Ads
  #2  
Old April 9th 05, 08:07 PM
Niek Otten
external usenet poster
 
Posts: n/a
Default

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

"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  
Old April 9th 05, 08:30 PM
Fredrik Wahlgren
external usenet poster
 
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  
Old April 10th 05, 12:59 PM
BayComp
external usenet poster
 
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%)
> Edit>Copy
> Select your data
> Edit>Paste 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

>
>
>

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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 06:00 PM.


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