Level 3LET and LAMBDAPractice, 3 min
SCAN: a running cash balance
The task
In C2, show the cash balance after every week. Start from the opening cash in E2 and add each week's net cash, with
SCAN.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Week | Net cash | Balance | Opening cash | |
| 2 | Wk 1 | $4,200 | $25,000 | ||
| 3 | Wk 2 | -$6,800 | |||
| 4 | Wk 3 | -$3,100 | |||
| 5 | Wk 4 | $9,400 | |||
| 6 | Wk 5 | -$12,500 | |||
| 7 | Wk 6 | $2,600 | |||
| 8 | Wk 7 | -$1,900 | |||
| 9 | Wk 8 | $7,300 |