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

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

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.

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

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.

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.