LAMBDA & LET › LET61 / 67

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

MediumFreeLET

LET: name the steps of a calculation

Adit runs a beverage wholesale shop in Mataram. Buyers who spend at least Rp1,000,000 get a 5% discount, and every bill is then charged 11% VAT. He wants a readable total formula that names each step.

Task

Fill D2:D6 with the amount due using LET:

subtotal = cases (B) × price per case (C)
discount = 5% of subtotal if subtotal is at least 1000000, otherwise 0
final result = (subtotal − discount) × 1.11

Cells to fillD2:D6

Required functionsLET

Expected result

Loading the expected result…

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

Hint 1
The LET pattern: LET(name1, value1, name2, value2, final_result). A name you have defined can be used in the arguments after it.
Hint 2
The discount uses IF: IF(subtotal>=1000000, subtotal*5%, 0).
Hint 3
The last argument of LET is (subtotal-discount)*1.11.

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

=LET(subtotal,B2*C2,discount,IF(subtotal>=1000000,subtotal*5%,0),(subtotal-discount)*1.11)

Write it in D2, then fill down to D6.

Explanation

LET calculates subtotal once, uses it to decide the discount, then uses it again in the final result. The formula is shorter and easier to check than writing B2*C2 three times. Example: Kafe Senja spends 1,380,000, gets a 69,000 discount, then (1,380,000 − 69,000) × 1.11 = 1,455,210. LET names cannot look like cell addresses such as A1 or B2.

Starting worksheet: Sheet1
Row	A	B	C	D
1	Buyer	Cases	Price/case	Amount due
2	Warung Made	10	85,000
3	Kafe Senja	15	92,000
4	Toko Sinar	20	78,000
5	Kos Melati	4	85,000
6	Resto Pantai	12	120,000
7
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result