LET & LAMBDA › LAMBDA112 / 144

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

MediumFreeLAMBDA

LAMBDA: a home-made BMI formula

Rizal, a trainer at a gym in Medan, records the weight and height of new members. He wants to build his own BMI function with LAMBDA and test it directly in a cell before saving it in Name Manager.

Task

Fill D2:D7 with BMI = weight (kg) divided by the square of height in meters. Height in column C is in cm. Write it as a LAMBDA with two parameters (weight and height) that is called right away with B2 and C2, then copy it down.

Cells to fillD2:D7

Required functionsLAMBDA

Expected result

Loading the expected result…

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

Hint 1
The shape is LAMBDA(parameter1, parameter2, calculation). To run it right away, put the arguments in parentheses straight after it: LAMBDA(…)(B2, C2).
Hint 2
Convert cm to meters by dividing by 100, then square it: (height/100)^2.
Hint 3
Pattern: =LAMBDA(weight, height, weight/…)(B2, C2).

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:D7

=LAMBDA(weight,height,weight/(height/100)^2)(B2,C2)

Write it in D2, then fill down to D7.

Explanation

=LAMBDA(weight,height,weight/(height/100)^2)(B2,C2) defines a function and calls it at once with the weight in B2 and the height in C2. For Andika: 68 / 1.70² = 23.5. If you forget the call parentheses (B2,C2), Excel returns #CALC! because the function is only defined, never run. Once it works, save the LAMBDA(…) part in Name Manager as BMI, and then just write =BMI(B2,C2) anywhere.

Starting worksheet: Sheet1
Row	A	B	C	D
1	Member	Weight (kg)	Height (cm)	BMI
2	Andika	68	170
3	Bunga	54	158
4	Chandra	85	175
5	Desi	47	160
6	Eko	92	168
7	Fitri	60	163
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result