R
ROBINTHEGREAT
HOW DO I INCREASE THE NUMBERS IN A COLUMN BY 5.5%
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
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
to increase,
copy it, select the column and do edit>paste special and select multiply
--
Regards,
Peo Sjoblom
W
Wigi
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.
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.
R
Rick Rothstein \(MVP - VB\)
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
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
J
John Huynh
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
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
P
Peo Sjoblom
=A3*(1+A1)
--
Regards,
Peo Sjoblom
--
Regards,
Peo Sjoblom
John Huynh said: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