Just to reiterate for my own understanding - you are saying that a loop is impossible...TerryE wrote:You can't do this for architectural reasons. A spreadsheet is a functional model and not a procedural model. That is cells are calculated as formula which transforms other cells. These dependencies for a directed graph. For the sheet to be computable then you can't have any loops in this graph, and C1 = A1 + C1 is exactly that.
I am not interested in the history if that makes it easier.TerryE wrote:If you want to keep a record of entries in A1 then you need to keep a history in say D1,E1,F1... and then you can say C1 = SUM(D1:IV1) or whatever, but then you still need to manually (or through a macro maintain that history
Yes, that's what I am saying.toad wrote:Just to reiterate for my own understanding - you are saying that a loop is impossible...
So you are not interested in any result at all after a single typo occured.I am not interested in the history if that makes it easier.
K, don't bring this one into play. It isn't what toad wants, but is a cludgy version of goal seek that doesn't work very well. What this assumes is that the cyclic relationship will converge to a limit solution. The calculation is reapplied N times or until the cell values converge within some tramline. AVOIDkingfisher wrote:It is possible to enable interation: Menu: Tools >Options >OO Calc >Calculate : Iterative References.
Wow this does indeed sounds possible. Your explanation, comprehensive it might be to the initiated, means very little to me. I am quite willing to read through the forum and do "my bit" but I'm not sure which term I should search for to get the relevant bits and pieces.TerryE wrote:What you could do is to record or write a macro which when you run in copies a range in column A, then does a Paste Special->Values to the equivalent cells in B, and then a Paste Special->Add Values to the equivalent cells in C and then deletes the contents of A. You can then attach this to a key or a button (other posts tell you how to do this).
As for the comment about typos - dead right! The ideal situation would be to click on the input field and be presented with an input mask where you input number after number which is added onto the total - and the record itself is stored in some obscure (i.e. invisible) part of the spreadsheet.