How to update a column of numbers?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cutie_pyie - 23 Jul 2008 05:09 GMT

Hi all,
I need to know how to update a column of numbers (dollars & cents values) in
MS Excel.

I have a rather large/long column of numbers consisting of dollars & cents
in MS Excel - I want to be able to select a certain number of cells/rows in
the column and increase the amounts in each cell by a fixed percentage.
IE: Column A, rows 1-125 have different values in each cell,
I want to increase each cell amount by 20%.
Column A, rows 126-300 - I want to increase each cell amount by 25%.

Can anyone please help me to do this?

Thanks a bunch!!!
Cindy

Reply to this Message

JE McGimpsey - 23 Jul 2008 06:06 GMT

> Hi all,
> I need to know how to update a column of numbers (dollars & cents values) in
[quoted text clipped - 6 lines]
> I want to increase each cell amount by 20%.
> Column A, rows 126-300 - I want to increase each cell amount by 25%.

One way (if fractional cents don't matter, or if you have 'Set precision
as displayed' set in Preferences/Calculation):

In a blank cell, enter 1.2. Copy the cell. Select A1:A125. Choose
Edit/Paste Special, selecting the Values and Multiply radio buttons.
Click OK.

Use a similar procedure on A126:A300, using 1.25.

If you need to round to the nearest penny:

In a blank column (say B) enter

B1: =ROUND(A1*1.2,2)

Copy B1 down to B125. Then

B126: =ROUND(A126*1.25,2)

Copy B126 down to B300.

Select Column B. Copy it. Select Column A. Choose Edit/Paste Special,
selecting the Values radio button. Click OK. Delete Column B.

Reply to this Message

Mac Forum / Applications / Excel / July 2008

How to update a column of numbers?