Ask Your Question

adding numbers within a single cell [closed]

asked 2012-10-31 21:42:03 +0200

jonyd1 gravatar image

Hey everyone - I was wondering if it's possible to have Calc automatically add numbers as they are entered within a single cell. For example, I have "4" in a cell, then I later come back, click on that cell, and type "5". Would it be possible to have Calc display "9"? Then if I came back again and clicked on it, typed "3", Calc would display "12", etc. I have a feeling this isn't possible, but figured it couldn't hurt to ask. Thanks!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-18 22:25:17.343557

1 Answer

Sort by » oldest newest most voted

answered 2012-11-01 02:12:31 +0200

Ron gravatar image

Code your initial entry in the cell as "=4". When you return to add the 5, edit the cell (just hit F2) and append "+5" to the "=4", giving "=4+5". Hit enter and the resulting "9" will be displayed.

edit flag offensive delete link more

Question Tools


Asked: 2012-10-31 21:42:03 +0200

Seen: 1,038 times

Last updated: Nov 01 '12