Excel annoyance: How to maintain formulas in a ledger?
- by davidcl
A common use of Excel is to create a spreadsheet which functions as a transaction ledger of some kind, where one or more fields in each row is calculated by adding a value or values from the current row to a value from the previous row.
For example, if column C holds the value of a transaction and column D holds the balance, then the formula in…