Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Aaron
 
Posts: n/a
Default changing the value of each cell in a range by a certain percentage

Hello,

Is there an easy way to select a range of cells and change the value of each
cell by the same percentage without adding formula columns?

Thank you,
Aaron
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
try:
- put 1.05 in an empty cell (for a 5% increase) and copy this cell
- select your values
- goto 'Edit - Paste Special' and choose 'Multiply'

--
Regards
Frank Kabel
Frankfurt, Germany
"Aaron" schrieb im Newsbeitrag
...
Hello,

Is there an easy way to select a range of cells and change the value of
each
cell by the same percentage without adding formula columns?

Thank you,
Aaron



  #3   Report Post  
Faulk
 
Posts: n/a
Default


Aaron wrote:
Hello,

Is there an easy way to select a range of cells and change the value

of each
cell by the same percentage without adding formula columns?

Thank you,
Aaron


Yes, in a seperate cell, enter 1 plus the percentage change you wish to
add. for example, if you want to increase your range by 10%, enter 1.1
in a cell, copy it, then select your entire range, Edit, Paste Special,
under Operation, select Multiply, then OK. Your range will be
incremented by the percentage you indicated.

  #4   Report Post  
Bernard Liengme
 
Posts: n/a
Default

Let's say you want to increase the vales in A1:A10 by 15%
In empty cell (we'll call it Z1) type 1.15
Copy Z1; select A1:A10 and use Edit | Paste Special specifying Multiply in
the popup dialog box.
Your numbers have been increased.
All that remains is housekeeping - delete Z1

best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"Aaron" wrote in message
...
Hello,

Is there an easy way to select a range of cells and change the value of
each
cell by the same percentage without adding formula columns?

Thank you,
Aaron



  #5   Report Post  
Aaron
 
Posts: n/a
Default

Hello, and thank you.

Is there a way for it to not overwrite the existing formats in the selected
range?

Thank you,
Aaron

"Faulk" wrote:


Aaron wrote:
Hello,

Is there an easy way to select a range of cells and change the value

of each
cell by the same percentage without adding formula columns?

Thank you,
Aaron


Yes, in a seperate cell, enter 1 plus the percentage change you wish to
add. for example, if you want to increase your range by 10%, enter 1.1
in a cell, copy it, then select your entire range, Edit, Paste Special,
under Operation, select Multiply, then OK. Your range will be
incremented by the percentage you indicated.




  #6   Report Post  
Gord Dibben
 
Posts: n/a
Default

Aaron

When doing the Paste Special check "Formulas"(under Paste) as well as
"Multiply"

Gord Dibben Excel MVP

On Wed, 15 Dec 2004 12:31:04 -0800, "Aaron"
wrote:

Hello, and thank you.

Is there a way for it to not overwrite the existing formats in the selected
range?

Thank you,
Aaron

"Faulk" wrote:


Aaron wrote:
Hello,

Is there an easy way to select a range of cells and change the value

of each
cell by the same percentage without adding formula columns?

Thank you,
Aaron


Yes, in a seperate cell, enter 1 plus the percentage change you wish to
add. for example, if you want to increase your range by 10%, enter 1.1
in a cell, copy it, then select your entire range, Edit, Paste Special,
under Operation, select Multiply, then OK. Your range will be
incremented by the percentage you indicated.



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
Maintaining cell reference after sorting GRITS Excel Discussion (Misc queries) 2 April 30th 23 07:42 PM
Passing a range name as an argument to the Index Function Michael Sharpe Excel Discussion (Misc queries) 3 September 5th 12 01:33 PM
Changing Cell Fill Colour Nick Excel Discussion (Misc queries) 4 December 6th 04 11:05 PM
Freezing a cell range JMorrell Excel Discussion (Misc queries) 3 December 3rd 04 07:09 PM
CELLS HAVING SAME NUMBER BY CHANGING ANY CELL JOHN MORREY Excel Discussion (Misc queries) 2 December 2nd 04 03:50 AM


All times are GMT +1. The time now is 08:41 AM.

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

About Us

"It's about Microsoft Excel"