LET & LAMBDA › LET111 / 144

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

EasyFreeLET

LET: total after discount and VAT

The finance team at a design agency in Bandung calculates a project invoice: the subtotal gets the discount first, then 11% VAT is added. Long formulas that repeat the same calculation are easy to mistype, so they want to name the intermediate result.

Task

In B6, calculate the invoice total with LET: store the subtotal after discount (B2 minus the B3 discount) in a name, then add VAT (B4) on that value.

Cells to fillB6

Required functionsLET

Expected result

Loading the expected result…

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

Hint 1
The shape of LET is LET(name, value, final_calculation).
Hint 2
The value after discount is B2*(1-B3). Name it, for example, net.
Hint 3
The final calculation is net*(1+B4).

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

B6

=LET(net,B2*(1-B3),net*(1+B4))

Explanation

=LET(net,B2*(1-B3),net*(1+B4)) computes 2,500,000 × 90% = 2,250,000, then × 111% = 2,497,500. The name net only exists inside this formula. The order matters: VAT is charged on the discounted value, not on the original subtotal. One LET can hold several names, for example LET(net,…,vat,…,net+vat).

Starting worksheet: Sheet1
Row	A	B
1	Item	Value
2	Subtotal	2,500,000
3	Discount	10%
4	VAT	11%
5
6	Invoice total
7
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result