Naming Steps With LET

Have you ever written a long formula that repeats the same calculation three or four times? Long formulas are hard to read, slow to recalculate, and painful to fix.

The LET function solves this. It lets you give a name to a value or calculation, then reuse that name throughout your formula. Think of it like jotting down a number on a sticky note so you don't have to recompute it.

LET is available in modern Excel (Microsoft 365 and Excel 2021) and in Google Sheets. In this lesson you will learn to name intermediate steps and make tangled formulas readable.

LET follows a simple repeating pattern: pairs of name and value, ending with a final calculation that uses those names.

• Define one or more names
• Give each name a value
• Finish with a result that uses the names

The very last argument is always the calculation that produces the output. Everything before it comes in name/value pairs.

Let's name a single value. Suppose cell A2 holds a price of 100. We can name it price and then double it.

Here LET creates the name price, assigns it the value from A2, and the final argument price*2 uses that name. The result is 200.

Notice how readable this is compared to =A2*2 when formulas grow longer. Names describe what the numbers mean.

The biggest payoff of LET is calculating something once and reusing it. Imagine you need a tax amount twice: once to show it and once to add it to a total.

Without LET you would write A2*0.2 in two places. With LET you compute it once under the name tax, then reference tax wherever you need it.

This is faster because the spreadsheet only does the multiplication a single time, and clearer because the intent is named.

LET happily accepts many name/value pairs. Just keep adding them before the final calculation. Each new name can even use names defined earlier.

In this example we name rate, then base, then a tax value built from both. Names are evaluated top to bottom, so tax can rely on rate and base already existing.

This chaining is what makes LET powerful. You can break a complicated formula into small, named steps that read like sentences.

• subtotal = quantity times price
• discount = subtotal times discount rate
• result = subtotal minus discount

Each step references the one before it. Anyone reading the formula can follow the logic line by line instead of decoding one giant expression.

Let's compute net pay. Gross is in B2, the tax rate in C2. We want gross minus tax, rounded to two decimals.

We name gross, compute tax from it, then return the rounded difference. The formula is long but each piece is obvious.

A LET name can hold the result of any function, not just arithmetic. This is great for lookups you would otherwise repeat.

Here we look up a value once with XLOOKUP, store it as found, and then check it. If the lookup misses we show a message; otherwise we use the value. The expensive lookup runs only once.

LET names have a few rules:

• Start with a letter or underscore, not a number
• No spaces (use unit_price not unit price)
• Cannot look like a cell reference such as A1 or TAX1
• Cannot match a built-in function name

Stick to clear lowercase words like total, rate, or net and you will be fine.

Good news: LET works the same way in Google Sheets. The syntax, the name/value pairs, and the final calculation are all identical.

This means formulas you build with LET are portable between Excel and Sheets, which is rare for newer functions. Whether your team uses Microsoft 365 or Google Workspace, LET reads the same.

Use LET whenever you notice:

• The same sub-expression appearing more than once
• A formula so long you lose track of what each part does
• A slow lookup or calculation you want to run only once

For a tiny formula like =A2+B2, LET is overkill. But the moment a formula starts repeating itself, LET makes it shorter, faster, and far easier to maintain.

Test your understanding of how LET is structured.

You learned that LET lets you name intermediate values and reuse them, making long formulas readable and faster.

• Syntax is repeating name, value pairs ending in a final calculation
• Later names can build on earlier names
• Calculate something once, reference its name many times
• Names must avoid spaces, leading digits, and cell-like text
• LET works identically in Excel and Google Sheets

Next you will go a step further and define your own reusable functions with LAMBDA.