=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%