Excel - HOW DO i INCREASE THE NUMBERS IN 1 COLUMN BY 5.5%?

Asked By ROBINTHEGREA on 08-Aug-08 05:43 PM
HOW DO I INCREASE THE NUMBERS IN A COLUMN BY 5.5%




Peo Sjoblom replied on 08-Aug-08 05:46 PM
put 1.055 in an empty cell, format it the same way as the numbers you want
to increase,
copy it, select the column and do edit>paste special and select multiply

--


Regards,


Peo Sjoblom
Wig replied on 08-Aug-08 05:48 PM
Hi

Write the value 1.055 in a cell.

Copy that cell.

Paste it over the cells to be changed, don't use paste, but Edit > Paste
Special > Multiply.

Delete the first cell again.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music
Rick Rothstein \(MVP - VB\) replied on 08-Aug-08 05:50 PM
Put 1.055 in an unused cell, select that cell and click Edit/Copy from
Excel's menu bar (or simply key in Ctrl+C), then select the cells you want
to change and click Edit/PasteSpecial from Excel's menu bar, click the
Multiply option button in the "Operations" section, then click OK. You can
now delete the 1.055 from the cell you put it in.

Rick
JohnHuyn replied on 09-Aug-08 10:51 PM
Hi Wigi

What is the way to have the same result but if I want to change the 5.5% in
the future? It means that can I change 5.5% to 6% and the formular will be
automatically revised.

I also have the same problem like Robin but it is as follows:
A1's value is 5%
A2 is a formula =$A$1
A3 is any value of 500

I want to copy and paste special A2 to A3 by using formula and divide but it
can not work. It supposed to have the result like A3 = 500/$A$1 in stead of
10,000. It worked well with excel 2003 but it does not with excel 2007. Could
any one help me.

John
Peo Sjoblom replied on 11-Aug-08 11:38 AM
=A3*(1+A1)




--


Regards,


Peo Sjoblom