Formula Problem

S

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?
 
K

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.
 
D

David Biddulph

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.
 
Top