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
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.
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.
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
