easyBoost · aggregation
Apply a fixed cashback rate down a column
Column A holds top-up amounts (RM) for four Boost e-wallet transactions. D1 holds a single fixed cashback rate used for every transaction. Write formulas in B1:B4, one per row, that compute cashback (amount × rate) for each row, always pointing at the same rate cell regardless of which row the formula sits in.
Starting grid
A1
| A | B | C | D | |
|---|---|---|---|---|
| 1 | 500 | 0.02 | ||
| 2 | 1200 | |||
| 3 | 80 | |||
| 4 | 3000 |
Show expected output▾
Stuck? Ask the coach for a nudge that won't give the answer away, or reveal the reference solution and a short walkthrough of why it works.
B1
| A | B | C | D | |
|---|---|---|---|---|
| 1 | 500 | 0.02 | ||
| 2 | 1200 | |||
| 3 | 80 | |||
| 4 | 3000 |