View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
macropod macropod is offline
external usenet poster
 
Posts: 329
Default How Do I get percentage of any figure in same Cell

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