Excel LET Function: How to Name and Reuse Calculations

Formulas & functions · Updated November 18, 2026

Use Excel’s LET function to give a name to a value or calculation, then use that name elsewhere in the same formula. It can make long formulas easier to read, update, and troubleshoot. For example, with a price in B2, a discount rate in C2, and a tax rate in D2, this formula calculates the discounted price plus tax: =LET(discountedPrice,B2*(1-C2),taxAmount,discountedPrice*D2,discountedPrice+taxAmount). If B2 is 100, C2 is 10%, and D2 is 8%, the result is 97.2.

What You’ll Need

  • Microsoft Excel for Microsoft 365 or Excel 2021 or later. LET is also available in supported versions of Excel for Mac and Excel for the web. Excel 2019 and earlier do not support it.
  • A workbook with the data your formula will use. The examples below use ordinary cell references, so you can replace them with the cells in your own sheet.
  • A basic understanding of formulas and cell references. You do not need to create named ranges in Name Manager; LET names apply only within the formula where you define them.

Step-by-Step

  1. Choose a calculation to simplify. Look for a formula that repeats the same calculation, uses several intermediate steps, or is difficult to understand at a glance. LET is most helpful when a calculation has a meaningful intermediate result, such as a discounted price, a subtotal, or a filtered value. It does not change the underlying data; it changes how you organize the formula.
  2. Identify the inputs and intermediate results. Write down which cells the formula needs and what each intermediate value means. In the opening example, B2 contains the original price, C2 the discount rate, and D2 the tax rate. The discounted price is an intermediate result, and the tax amount is another. Giving these steps clear names makes the final calculation easier to follow.
  3. Select the cell for the answer and start the function. Click the destination cell, type an equals sign, and begin typing LET followed by an opening parenthesis. Excel may show LET in its function suggestions; select it or continue typing. You can enter the whole formula in the cell or in the formula bar.
  4. Enter a name and the value or calculation for that name. LET takes pairs: a name followed by the value or calculation assigned to it. Separate arguments with commas. For the discounted-price example, the first pair assigns the name discountedPrice to the original price after the discount. The next pair assigns taxAmount to the tax calculated on that discounted price.
  5. Finish with the calculation that returns the answer. After the name-and-value pairs, enter a final expression that uses the names you defined. In the example, the last expression adds the discounted price and its tax amount. Close the parenthesis and press Enter. The final expression is required; LET does not display a list of the named values by itself.
  6. Check the result against a simple calculation. For the opening example, a price of 100 less a 10% discount is 90. Eight percent tax on 90 is 7.2, so the total is 97.2. Checking a small example like this helps confirm that the references, rates, and order of operations are correct before you fill the formula down a larger table.
  7. Use the formula bar to review or edit the formula. Click the result cell and inspect the formula bar. Check that each name is followed by its intended calculation and that the last argument is the answer you want returned. If you change a cell reference or calculation, press Enter to apply the edit. The names inside LET do not appear in other cells and cannot be referenced from another formula.
  8. Copy the formula only after checking its references. If you need the calculation on other rows, use the fill handle or copy and paste the formula. Relative references such as B2 and C2 normally adjust as the formula moves. Use dollar signs for an absolute reference when an input, such as a fixed rate stored in one cell, must stay put. Test a copied row to make sure it points to the intended data.
  9. Try a decision-making example. Suppose sales amounts are in B2:B6 and a target is in E2. With 120, 150, 80, 100, and 50 in B2:B6, and 450 in E2, this formula adds the sales and reports whether the target is met: =LET(totalSales,SUM(B2:B6),target,E2,IF(totalSales>=target,"Target met","Below target")). The sales total is 500, so the displayed result is Target met. The names totalSales and target make the test easier to understand than a formula with unexplained values.

Common Mistakes

Leaving out the final calculation: LET needs a final expression that returns a result, after its name-and-value pairs. If you stop after defining a name, Excel cannot tell what to display. Review the end of the formula and make sure it contains the intended answer, followed by the closing parenthesis.

Putting arguments in the wrong order: Each name must be followed by its value or calculation. A name is not a label you can place anywhere in the formula. Keep the pairs together and put the final calculation last. If you add another pair, place it before that final expression.

Using an invalid or confusing name: LET names cannot contain spaces and must follow Excel’s naming rules. Avoid names that look like cell references, and choose names that describe the value without being so long that they make the formula harder to scan. Names are not case-sensitive, so rate and RATE refer to the same name.

Reusing a name accidentally: Defining the same name more than once can make a formula confusing or produce a name-related error. Give each intermediate value a distinct label, such as subtotal and taxAmount, and check the spelling each time you use it.

Expecting a LET name to work in another cell: Names defined inside LET exist only within that one formula. If you need a reusable name across multiple formulas, create a workbook-level or worksheet-level name separately using Excel’s name tools, or define the needed value in a cell.

Using the wrong argument separator: The examples use commas, as requested for standard English-language formula syntax. Excel’s list separator can depend on regional settings. If your Excel expects semicolons, it may reject a comma-separated formula or convert separators when you enter it. Follow the separator Excel uses in your installation.

Tips

  • Use names that explain what a value represents, such as netPrice, hoursWorked, or salesTotal. A meaningful name can save you from having to mentally decode a long series of cell references.
  • Define values in the order you need them. A later name can use an earlier one, which lets you build a calculation in readable stages. Do not rely on a name before it has been defined.
  • Keep the final expression focused. LET improves organization, but it does not automatically make a complicated calculation correct. If a formula has many separate jobs, consider splitting some steps into helper cells so each part is easier to inspect.
  • Use cell references for values that change. For example, putting a target or rate in a clearly labelled cell makes it easier to update than embedding a fixed number in a formula. Check whether that reference should be relative or absolute before copying the formula.
  • Use descriptive names without spaces. Camel case, such as monthlyTotal, is one readable option. Underscores can also help distinguish words. Be consistent within a workbook so that similar formulas are quick to compare.
  • Use LET when a value is repeated or deserves a clear label, not simply to make every short formula longer. A small formula that is already obvious may be easier to maintain without additional names.

Troubleshooting

Excel shows #NAME?: Confirm that you are using Microsoft 365 or Excel 2021 or later, and check that LET is spelled correctly. Also inspect every name for spaces, invalid characters, or a spelling mismatch between its definition and later use. A name that resembles a cell reference can also cause problems.

Excel reports that there are too few or too many arguments: Check that every name has a value or calculation after it, and that the final result expression is present. Look for a missing comma, an extra comma, or a parenthesis in the wrong place. Counting the name-and-value pairs can help: each pair has two arguments, followed by one final calculation.

The formula appears in the cell instead of a result: Check whether the cell is formatted as Text or whether an apostrophe was entered before the equals sign. Change the cell format to General, then edit the formula and press Enter. Also confirm that Show Formulas is not enabled on the Formulas tab; when it is, Excel displays formulas across the sheet instead of their calculated values.

The result is wrong but there is no error: Verify each referenced cell and the intended order of operations. Check whether percentages are stored as percentages, such as 10%, rather than as whole numbers such as 10. Test an intermediate calculation separately in an unused cell if needed, then compare it with the value you expected. Remove the temporary check when you are finished.

A copied formula uses the wrong input: Inspect the references in the copied row. Relative references shift when copied; absolute references marked with dollar signs stay fixed. If the formula should always use a rate in one cell, lock that reference before filling down. If each row needs its own rate, leave the reference relative.

Frequently Asked Questions

What does LET do in Excel?
LET assigns names to values or calculations within a single formula and then uses those names in its final calculation. This can improve readability and avoid repeating the same expression.

Which Excel versions support LET?
LET is available in Microsoft 365 and Excel 2021 or later, including supported Mac and web editions. It is not available in Excel 2019 or earlier, so a workbook using LET may not calculate correctly in those versions.

Can I use spaces in LET names?
No. Use a single valid name without spaces, such as orderTotal or order_total. Choose a name that follows Excel’s naming rules and does not look like a cell reference.

Can LET define more than one name?
Yes. Add as many name-and-value pairs as the calculation needs, then put the final expression last. Excel supports up to 126 name/value pairs in one LET function, though a formula with many pairs may be easier to maintain as several smaller steps.

Are LET names available throughout the workbook?
No. A name created by LET is local to that formula. It cannot be used in another cell unless you define it again there. For a shared name, create a separate workbook or worksheet name.

Does LET make a formula calculate faster?
It can avoid recalculating a repeated expression within the LET formula, and it often makes the formula easier to maintain. The speed improvement depends on the calculation and workbook, so use LET primarily for clear structure and avoid assuming every formula will run faster.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.