Calculate every running balance with SCAN
Your goal: Start from an explicit opening balance and return the state after each signed entry, in source order.
Full task requirements
Enter one SCAN formula in G5 to return eight balances in G5:G12. Start with opening balance G2 and add C2:C9 in source order. Each output is the balance after that entry, not just the final total.
Receipts, payments and zero changesBalance after entry 1
Opening balance · G2: 100
| # | ||||
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 | ||||
| 7 | ||||
| 8 | ||||
| 9 |
Step 1 of 8
Balance after entry 1
Rules for this step
Keep G2 and the inclusive prefix of signed changes ending at this entry. Every change is processed, including zero; the final balance alone is not a running report.
Calculation rule
opening balance + every change through this entry