Add 10% to the existing value in a cell

  • Thread starter LOOKIN FOR FORMULAS
  • Start date
L

LOOKIN FOR FORMULAS

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.
 
C

CLR

Enter 1.1 in an unused cell somewhere, then Copy it and select the value you
wish to change and right-click > PasteSpecial > Multiply

Vaya con Dios,
Chuck, CABGx3
 
W

Wigi

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
 
J

James

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.
Click to expand...

=(C4*.10)+(C4)

This should do it. (1.00 * .10) + (1.00) = 1.10
 
L

LOOKIN FOR FORMULAS

Thank you for your reply.
But excel doesn't let me put that in. If I use the same cell number, excel
doesn't use the value, it emptys it.
Help Thanks
 
C

Conan Kelly

LOOKIN FOR FORMULAS,

Please read the other responses to your post. Those will do what you asked.

James answer will kinda do what you ask, but instead of replacing the value
in the cell, it will keep the original value and display your desired result
in a different cell.

What you are asking can not be done with a formula. You need to change the
value of the cell. The other 2 responses will change the value of the cell
(Paste Special>Multiply).

HTH,

Conan
 
J

James

Thank you for your reply.
But excel doesn't let me put that in. If I use the same cell number, excel
doesn't use the value, it emptys it.
Help Thanks





- Show quoted text -
Click to expand...

Does it have to be in the same cell?
 
Top