LET & LAMBDA › MAP, LAMBDA113 / 144

Progress is saved on this device. Sign in or sign up free to keep it in your account.

MediumFreeMAPLAMBDA

MAP: shipping fee from actual or volumetric weight

Ayu sells tempeh chips from Malang. Her parcels are light but the boxes are bulky, so the courier charges whichever is larger, the actual weight or the volumetric weight, rounded up to a whole kg.

Task

In D2, write one MAP + LAMBDA formula over two arrays (B2:B8 and C2:C8). For each parcel, take the larger of the actual and volumetric weight with MAX, round it up to a whole kg with ROUNDUP, then multiply by the per-kg rate in G1. The result spills into D2:D8.

Cells to fillD2:D8

Required functionsMAPLAMBDA

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
MAP can take more than one array: MAP(array1, array2, LAMBDA(a, b, …)). The LAMBDA is called once per row with the matching pair of values.
Hint 2
For one parcel, the billed weight is ROUNDUP(MAX(a, b), 0). If MAX is applied straight to B2:B8 and C2:C8, every number collapses into one; that is why you need MAP.
Hint 3
Pattern: =MAP(B2:B8, C2:C8, LAMBDA(actual, vol, … * G1)). Fill the middle with the billed weight of one parcel.

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

D2

=MAP(B2:B8,C2:C8,LAMBDA(actual,vol,ROUNDUP(MAX(actual,vol),0)*G1))

Explanation

=MAP(B2:B8,C2:C8,LAMBDA(actual,vol,ROUNDUP(MAX(actual,vol),0)*G1)) handles the parcels one at a time. KRP-106 weighs only 1.5 kg, but its volumetric weight is 4.2 kg, so 5 kg is billed, Rp45,000. The plain formula =ROUNDUP(MAX(B2:B8,C2:C8),0)*G1 returns a single number because MAX takes the largest value across both columns at once. MAP makes MAX, MIN, AND and other summary functions work row by row.

Starting worksheet: Sheet1
Row	A	B	C	D	F	G
1	Tracking no.	Actual weight (kg)	Volumetric weight (kg)	Shipping fee	Rate per kg	9,000
2	KRP-101	0.4	0.9
3	KRP-102	1.2	2.6
4	KRP-103	2.0	1.5
5	KRP-104	3.7	2.4
6	KRP-105	0.8	0.5
7	KRP-106	1.5	4.2
8	KRP-107	5.1	3.0
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result