Menu
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
ABCD
15000.02
21200
380
43000
Show expected output
B1
ABCD
15000.02
21200
380
43000

Keep going

Company names are trademarks of their respective owners, used here only to describe practice material. mahir_data is not affiliated with, endorsed by, or sponsored by any company named on this site. Terms.