View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
D D is offline
external usenet poster
 
Posts: 121
Default 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