HOW DO I INCREASE THE NUMBERS IN A COLUMN BY 5.5%

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 editpaste special and select multiply

--


Regards,


Peo Sjoblom

"ROBINTHEGREAT" wrote in message
...
HOW DO I INCREASE THE NUMBERS IN A COLUMN BY 5.5%

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


"ROBINTHEGREAT" wrote:

HOW DO I INCREASE THE NUMBERS IN A COLUMN BY 5.5%

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

"Wigi" wrote:

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


"ROBINTHEGREAT" wrote:

HOW DO I INCREASE THE NUMBERS IN A COLUMN BY 5.5%

=A3*(1+A1)




--


Regards,


Peo Sjoblom

"John Huynh" wrote in message
...
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

"Wigi" wrote:

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


"ROBINTHEGREAT" wrote:

HOW DO I INCREASE THE NUMBERS IN A COLUMN BY 5.5%

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


"ROBINTHEGREAT" wrote in message
...
HOW DO I INCREASE THE NUMBERS IN A COLUMN BY 5.5%