[suzi_wells]

My boss has given me a spreadsheet with about 6000 different prices on, which
all need to be increased by 3.63%. Is there any way of creating a formula to
add the percentage to the figures already entered, wihtout having to manually
work out and change each figure?

[Kevin B]

Insert a helper column to the right of the prices that need to be upgraded
and enter the following formula, replacing A1 with the first pricing cell to
the left of the formula:

=ROUND(A1+(A1*0.0363),2)

Copy the formula down the entire length of the column

Now copy all the cells with the formula.

Move to the first cell in the old price column and click EDIT on the menu,
select PASTE SPECIAL and then click the VALUES option button and click OK.
The old prices are now replaced with the new prices. You can now delete
your helper column.

Hope this helps.
--
Kevin Backmann


"suzi_wells" wrote:

My boss has given me a spreadsheet with about 6000 different prices on, which
all need to be increased by 3.63%. Is there any way of creating a formula to
add the percentage to the figures already entered, wihtout having to manually
work out and change each figure?

[T. Valko]

See this:

http://www.contextures.com/xlVideos03.html#Paste2003

--
Biff
Microsoft Excel MVP


"suzi_wells" wrote in message
...
My boss has given me a spreadsheet with about 6000 different prices on,
which
all need to be increased by 3.63%. Is there any way of creating a formula
to
add the percentage to the figures already entered, wihtout having to
manually
work out and change each figure?

[David Biddulph[_2_]]

If you want to do it by a formula, use =A2*1.0363 or =A2*(1+3.63%)

Otherwise, put 1.0363 in a cell, Copy, then select your range of cells,
Edit/ Paste Special/ Multiply.
--
David Biddulph

"suzi_wells" wrote in message
...
My boss has given me a spreadsheet with about 6000 different prices on,
which
all need to be increased by 3.63%. Is there any way of creating a formula
to
add the percentage to the figures already entered, wihtout having to
manually
work out and change each figure?

[Bob Phillips[_3_]]

See response in .programming.

--
__________________________________
HTH

Bob

"suzi_wells" wrote in message
...
My boss has given me a spreadsheet with about 6000 different prices on,
which
all need to be increased by 3.63%. Is there any way of creating a formula
to
add the percentage to the figures already entered, wihtout having to
manually
work out and change each figure?