Published on
A formula can calculate correctly while remaining difficult to understand. LET gives intermediate values names within a formula. LAMBDA describes a reusable calculation. Both help express business rules clearly, but they solve different problems.
Microsoft lists LET for Microsoft Excel in Microsoft 365 and for Microsoft Excel 2021 and Microsoft Excel 2024. Its LAMBDA documentation lists Microsoft Excel in Microsoft 365 and Microsoft Excel 2024. Check the recipient's actual version before sharing a workbook that relies on either function. Microsoft on LET, Microsoft on LAMBDA.
Suppose we sell twelve items at 7.50 EUR each, with a ten percent discount. This formula returns 81 EUR:
=12*7.5*(1-0.1)LET allows us to name the inputs:
=LET(quantity,12,unit_price,7.5,discount,0.1,quantity*unit_price*(1-discount))The final argument calculates the result. The names apply only within this LET expression. They do not create input cells or workbook-wide names.
If quantity, unit price and discount are stored in A2, B2 and C2, the formula becomes:
=LET(quantity,A2,unit_price,B2,discount,C2,quantity*unit_price*(1-discount))The benefit becomes clearer when an intermediate expression is needed several times. Naming it makes the calculation easier to follow. Any speed improvement depends on the workbook's actual calculations; readability is already a useful reason to consider LET.
A price after discount needs two inputs: the original price and a discount expressed as a decimal. The rule is price*(1-discount). We can define it and immediately call it with 100 EUR and a ten percent discount:
=LAMBDA(price,discount,price*(1-discount))(100,0.1)The result is 90 EUR. The second pair of parentheses supplies the arguments for this call. A LAMBDA definition entered in a cell without being called produces a calculation error.
To reuse the rule, define the workbook name PRICE_AFTER_DISCOUNT in Name Manager with this definition:
=LAMBDA(price,discount,price*(1-discount))Another cell can then call:
=PRICE_AFTER_DISCOUNT(A2,B2)With 100 in A2 and 0.1 in B2, the result is again 90. The definition belongs to the workbook; other files do not automatically acquire it. Microsoft on LAMBDA and Name Manager.
Start with a calculation whose expected results are known. Name repeated expressions with LET or express a recurring rule with LAMBDA where this improves clarity. Test ordinary inputs, zero, a full discount and unsuitable input. A descriptive name supports understanding but does not establish that the calculation is correct.
The examples use English formula syntax, decimal points and commas between arguments. Other language and regional settings may require different syntax. Compatibility with another spreadsheet program must be checked against its actual functions, version and file format.
For tables that grow with their data, continue with structured references in Microsoft Excel. When a workbook becomes operationally important, the Grassroot IT framework explains how to organise responsibility, verification and sustained use.
Technical review: 14 November 2026. The examples were checked in the installed Microsoft Excel version; older versions were assessed through the linked manufacturer documentation.
