Formula Problem

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

 

[Bernard Liengme]

Yes, and it is very easy
1) with formula: let's say the first price in in C2. Insert a new empty
column D. In D2 type =C1*(1+3.63%). Copy this down the column; the quickest
way is to right click D2's fill handle which is the small solid square in
lower right corner when the cell in selected.
If you wish now to get rid of the old values we first convert the formulas
to values. Select all the entries in D; use Copy then with them still
selected use Edit | Paste Special with Values specified

2) without formulas; In any empty cell type =1+3.63%; copy this cell; select
all the old prices and use Edit | Paste Special with Multiply specified

Make use you back up the file before you begin to experiment

best wishes

 

[Bob Phillips]

In a spare cell type 1.0363. Copy that cell.

Select all of the values to be increased.
Goto Edit>PasteSpecial and click the Multiply button.
OK out.

Clear that spare cell.