Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel: Add/subtract to existing value in same cell
When there is an exisitng value in a cell and there is a value to be
subtracted or added to the exisitng value, a separate calculator needs to be used. Can Excel perform this function and eliminate the need for the separate calculator? |
#2
|
|||
|
|||
Not without using a macro.
"DOING MY BEST" wrote: When there is an exisitng value in a cell and there is a value to be subtracted or added to the exisitng value, a separate calculator needs to be used. Can Excel perform this function and eliminate the need for the separate calculator? |
#3
|
|||
|
|||
It can with code, but the complexity hardly makes it worthwhile IMO.
-- HTH RP (remove nothere from the email address if mailing direct) "DOING MY BEST" <DOING MY wrote in message ... When there is an exisitng value in a cell and there is a value to be subtracted or added to the exisitng value, a separate calculator needs to be used. Can Excel perform this function and eliminate the need for the separate calculator? |
#4
|
|||
|
|||
A cell formula does not have memory. The only way to build in memory is
with VBA (You chould have a worksheet change event that updates the cell when there is a change in the cell). http://www.mcgimpsey.com/excel /accumulator.html As a practical matter, memory in a calculation is almost always a bad idea. How would you deal with data entry errors in the cell? If the running total somehow gets out of sync, how would you correct, or even detect it? Jerry DOING MY BEST wrote: When there is an exisitng value in a cell and there is a value to be subtracted or added to the exisitng value, a separate calculator needs to be used. Can Excel perform this function and eliminate the need for the separate calculator? |
#5
|
|||
|
|||
Jerry W. Lewis wrote:
A cell formula does not have memory. The only way to build in memory is with VBA (You chould have a worksheet change event that updates the cell when there is a change in the cell). If it's a one-time change (eg subtracting an offset from data), it is possible to use the "Paste Special" command. 1. Type the number to be subtracted/added in one cell. 2. Copy this cell. 3. Highlight the cell/range to be modified. 4. Use "Paste Special" (either right-click, or Edit-Paste Special) 5. Select the operation to be performed. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying cell names | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Excel to Excel, Cut & Paste, 1 cell, text, multiplies file size f. | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |