💻 Software
Excel annoyance: How to maintain formulas in a ledger?
Fresh5 days ago
Mar 15, 20266059 viewsConfidence Score0%
0%
Problem
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 …
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Excel annoyance: How to maintain formulas in a ledger?
Low Risk
For the balance formula in cell D3 use based on your example of C3 having the amount and D2 having the previous balance. This way when you insert a row, you can just type in the new value and copy the balance formula from one of the other rows. By u…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix