Add percentage to a whole column of numbers
 

I have found it most difficult to find a simple solution to this
question/problem.

I need to add a percentage to a column of numbers.
For example-

$500
$510
$520
$505
$515

I need to change these numbers to that new total plus the specified
percentage. The only solution I have found is to add another column and then
sum the numbers plus the percentage into the new column. The problem is that
this new column is associated with the original value, so I can't copy these
new totals correctly.

Add percentage to a whole column of numbers
 

To add, for example 7% to the column of numbers, put 1.07 in an un-used cell,
copy the cell, and then paste/special with the mulitply button checked onto
the column.


Each item in the column will be increased by 7%
--
Gary''s Student - gsnu200738


"VOLVORacr" wrote:

I have found it most difficult to find a simple solution to this
question/problem.

I need to add a percentage to a column of numbers.
For example-

$500
$510
$520
$505
$515

I need to change these numbers to that new total plus the specified
percentage. The only solution I have found is to add another column and then
sum the numbers plus the percentage into the new column. The problem is that
this new column is associated with the original value, so I can't copy these
new totals correctly.