---
title: 'LET and LAMBDA in Microsoft Excel'
url: 'https://spreadcheat.net/en/how-to/let-und-lambda-in-microsoft-excel'
markdown: 'https://spreadcheat.net/en/how-to/let-und-lambda-in-microsoft-excel.md'
lang: en
date: '2026-11-14'
description: 'Understand LET and LAMBDA in Microsoft Excel with named intermediate values, reusable calculations, tested examples and supported versions.'
taxonomy:
  category:
    - Guides
  tag:
    - 'Microsoft Excel'
---

[← All guides](https://spreadcheat.net/en/how-to)Published on 14.11.2026

# LET and LAMBDA in Microsoft Excel

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.

## Which versions support the functions?

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](https://support.microsoft.com/en-us/excel/functions/let-function), [Microsoft on LAMBDA](https://support.microsoft.com/en-us/excel/functions/lambda-function).

## LET names parts of a calculation

Suppose we sell twelve items at 7.50 EUR each, with a ten percent discount. This formula returns 81 EUR:

```excel
=12*7.5*(1-0.1)
```

LET allows us to name the inputs:

```excel
=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:

```excel
=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.

## LAMBDA makes a rule reusable

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:

```excel
=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:

```excel
=LAMBDA(price,discount,price*(1-discount))
```

Another cell can then call:

```excel
=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](https://support.microsoft.com/en-us/excel/functions/lambda-function).

## Introduce the functions deliberately

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](https://spreadcheat.net/en/how-to/strukturierte-bezuege-in-microsoft-excel). When a workbook becomes operationally important, the [Grassroot IT framework](https://grassroot.it/en/artikel/tabelle-zur-anwendung) 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.

[More guides ](https://spreadcheat.net/en/how-to)

---

## Navigation

- Parent: [Guides](https://spreadcheat.net/en/how-to.md)
- Previous: [Structured references in Microsoft Excel since 2007](https://spreadcheat.net/en/how-to/strukturierte-bezuege-in-microsoft-excel.md)
- Next: [PlanMaker tables, formulas and file exchange](https://spreadcheat.net/en/how-to/planmaker-tabellen-und-austausch.md)