Build a carrier by parcel shipping quote matrix
Enter one formula in G5. F2 selects the first 1–4 carriers in A2:D5; F3 selects the first 1–5 parcel weights in A12:E12. Return a numeric matrix with carriers as rows and parcels as columns, in source order, with no headings. Each quote is Base fee plus billable extra kg times Rate per kg, rounded to two decimals. Extra kg is MAX(0, parcel weight minus Included kg), rounded up to the next 0.5 kg. Exact increments stay unchanged. Even a zero-weight parcel pays the base fee. Unselected output positions remain empty.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View task requirements
Enter one formula in G5. F2 selects the first 1–4 carriers in A2:D5; F3 selects the first 1–5 parcel weights in A12:E12. Return a numeric matrix with carriers as rows and parcels as columns, in source order, with no headings. Each quote is Base fee plus billable extra kg times Rate per kg, rounded to two decimals. Extra kg is MAX(0, parcel weight minus Included kg), rounded up to the next 0.5 kg. Exact increments stay unchanged. Even a zero-weight parcel pays the base fee. Unselected output positions remain empty.
No account. No upload. Just try it.