How Do I get percentage of any figure in same Cell
Cheers Joel.
But that would give me two coloums, one for the orignal value, the other
with the answer, I just want it so that I enter 10 in the cell, and it auto
adds 25% to it giving me 12.50, So bascaly in cell A1, if I type in 10 and
then click out of the cell, cell A1 should say 12.50.
Cheers thou
"Joel" wrote:
add another column. Add the data to cell A1, then if cell B1 have the
formula =1.25*A1
"macropod" wrote:
Hi D,
Enter 1.25 into an unused cell
Copy the 1.25
Select the range you want to increase by 25%
Choose Edit|Paste Special|Values|Multiply
Delete the 1.25 from the cell you entered it into.
Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------
"D" wrote in message ...
Howdy Folks.
Example
In cell A1
Can I enter any figure and then add 25% to it, but it updates in the same
cell, rather than adding two cells together.
Cheers.
D
|