Use Excel LET to Calculate Repeated Expressions Automatically
Question details
The user needs a simpler way to calculate a repeated expression in one Excel formula without building formula text and evaluating it again.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet formula uses the same calculation multiple times and needs to reuse that result within a single formula.
- Observed behavior
- The goal is to calculate the expression directly once and return the final result without a second formula-evaluation step.
Check that your Excel version supports the LET function, such as Microsoft 365 or Excel 2021 and later. Identify the repeated expression and choose a short, meaningful variable name for it.
Use the LET function to store and reuse the calculation
Use LET when the same expression appears more than once in a formula and you want Excel to calculate it directly instead of generating formula text.
LET assigns a name to a value or expression inside one formula. Excel calculates the named expression and lets you reuse it in the final calculation, making long formulas easier to read and maintain.
Click the worksheet cell where you want the result to appear, then enter formula edit mode by pressing F2 or clicking the Formula Bar.
Enter LET with a variable name and the expression to calculate. For example, use =LET(x,C20,x+x*x+x), where x stores the value from cell C20.
After the variable definition, enter the calculation that uses it. In =LET(x,C20,x+x*x+x), Excel returns C20+C20*C20+C20 without repeating the cell reference.
Press Enter to calculate the result. Edit the expression after the variable name if the repeated calculation is more complex than a single cell reference.
Set workbook calculation to Automatic if formulas are not updating
Use this only when an existing formula does not recalculate after the referenced cells change.
Reuse expressions with LET in WPS Spreadsheets
WPS Spreadsheets lets you build clearer formulas by assigning a repeated value or calculation to a LET name and using that name in the result. This avoids formula-text workarounds while keeping the calculation in one editable cell formula.
- 1. Open the worksheet in WPS Spreadsheets: Launch WPS Office, open the workbook, and select the worksheet containing the repeated calculation.
- 2. Select the result cell: Click the cell that should display the calculated result, then click the formula input bar.
- 3. Enter a LET formula: Type a formula such as =LET(x,C20,x+x*x+x), replacing C20 and the final expression with your own calculation.
- 4. Apply and test the formula: Press Enter, then change a referenced cell value to confirm that the LET result recalculates as expected.
Frequently Asked Questions
What does LET do in an Excel formula?
LET gives a name to a value or calculation within the current formula. Use the syntax =LET(name, value_or_expression, calculation_using_name) to reuse that result without repeating the full expression.
Can I create more than one variable with LET?
Yes. Add additional name and value pairs before the final calculation, such as =LET(price,A2,quantity,B2,price*quantity). The last argument is the result Excel returns.
Why does Excel show #NAME? when I use LET?
#NAME? can indicate that your Excel version does not support LET or that the variable name is invalid. Use a current version of Excel and choose a name that does not conflict with a cell reference, such as C20.
Do I need INDIRECT to evaluate a formula built as text?
No, not when the calculation can be written directly as a formula. Use LET to store the expression or intermediate result; INDIRECT is intended to turn text into a cell reference and can make formulas harder to maintain.
How do I make Excel recalculate formulas automatically?
Go to Formulas > Calculation Options and select Automatic. If needed, press F9 to recalculate the open workbook after changing formula settings.
