LAMBDA & LET › LAMBDA62 / 67

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

MediumFreeLAMBDA

LAMBDA: a price + VAT function

Tiara runs an invitation design service in Surabaya. She often calculates the selling price = base price + 11% VAT, rounded to the nearest hundred rupiah. Before saving it as her own function, she wants to try LAMBDA first.

Task

Fill C2:C6 with the price after 11% VAT, rounded to the nearest hundred. Use a LAMBDA that is called right away: a function with one parameter price that multiplies by 1.11 and rounds with ROUND(…, -2), then call it with B2.

Cells to fillC2:C6

Required functionsLAMBDA

Expected result

Loading the expected result…

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

Hint 1
LAMBDA creates an unnamed function: LAMBDA(parameter, formula). To evaluate it right away, put the input in parentheses right after the LAMBDA.
Hint 2
Example pattern: =LAMBDA(x, x*2)(A2) returns twice the value of A2.
Hint 3
Replace x with price, make the formula ROUND(price*1.11, -2), and call it with B2.

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

C2:C6

=LAMBDA(price,ROUND(price*1.11,-2))(B2)

Write it in C2, then fill down to C6.

Explanation

=LAMBDA(price,ROUND(price*1.11,-2))(B2) creates a function with the parameter price, then calls it right away with the value of B2. The -2 in ROUND rounds to hundreds, so 248,000 × 1.11 = 275,280 becomes 275,300. In Google Sheets a LAMBDA is usually saved through Data > Named functions so you can call it like =PRICE_VAT(B2) anywhere in the spreadsheet. A LAMBDA written without the calling parentheses returns an error because the function has not been given a value.

Starting worksheet: Sheet1
Row	A	B	C
1	Package	Base price	Price incl. VAT
2	Digital invitation	150,000
3	Printed invitations (100 pcs)	870,000
4	Invitation video	320,000
5	Wedding logo design	248,000
6	Thank-you cards	99,000
7
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result