Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add 10% to the existing value in a cell
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add 10% to the existing value in a cell
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 "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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add 10% to the existing value in a cell
On Dec 4, 2:10 pm, LOOKIN FOR FORMULAS <LOOKIN FOR
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. =(C4*.10)+(C4) This should do it. (1.00 * .10) + (1.00) = 1.10 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add 10% to the existing value in a cell
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 "James" wrote: On Dec 4, 2:10 pm, LOOKIN FOR FORMULAS <LOOKIN FOR 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. =(C4*.10)+(C4) This should do it. (1.00 * .10) + (1.00) = 1.10 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add 10% to the existing value in a cell
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 SpecialMultiply). HTH, Conan "LOOKIN FOR FORMULAS" wrote in message ... 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 "James" wrote: On Dec 4, 2:10 pm, LOOKIN FOR FORMULAS <LOOKIN FOR 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. =(C4*.10)+(C4) This should do it. (1.00 * .10) + (1.00) = 1.10 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add 10% to the existing value in a cell
On Dec 4, 2:45 pm, LOOKIN FOR FORMULAS
wrote: 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 "James" wrote: On Dec 4, 2:10 pm, LOOKIN FOR FORMULAS <LOOKIN FOR 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. =(C4*.10)+(C4) This should do it. (1.00 * .10) + (1.00) = 1.10- Hide quoted text - - Show quoted text - Does it have to be in the same cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I add 1 # to an existing # in a cell? | Excel Discussion (Misc queries) | |||
Modify an existing Cell formula using VBA | Excel Discussion (Misc queries) | |||
download existing spreadsheets into another existing spreadsheet | Excel Discussion (Misc queries) | |||
Leave existing data in a cell alone | Excel Worksheet Functions | |||
Use VBA to add to existing number in cell | Excel Discussion (Misc queries) |