View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Wigi Wigi is offline
external usenet poster
 
Posts: 396
Default Add 10% to the existing value in a cell

Put the value 1.1 in a cell.

Copy that cell, select the cell with the 1.

Go to Edit, then choose Paste Special, and then Multiply.

Delete the 1.1 again.

Wigi

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"LOOKIN FOR FORMULAS" wrote:

I need to add 10% to a value that already exist in the cell
Example. Cell C4 contains the value $1.00
I want to add 10% to $1.00 and replace the $1.00 with the answer $1.10
HELP.