Function reference

LET in Excel & Google Sheets

LET is used in 1 formula pattern in this library. Browse worked examples below, or use the generator to build a custom variation for your specific data.

1 advancedBuild a custom LET formula →

When to use LET

Simplify a long nested formula by naming repeated sub-expressions, or avoid calculating the same range lookup multiple times in a single formula.

Worked examples (1)

Array Formulasadvanced

Reuse calculations in one formula with LET

=LET(rate,B1/12,periods,B2*12,PMT(rate,periods,-B3))

Open formula LET reference

Common errors with LET

LET is not available

LET requires Excel 365 or Excel 2021. It is not available in Excel 2019 or earlier.

Circular name reference

A name cannot reference itself or a name defined later in the same LET. Define names in the order they are needed.

Frequently asked questions

How many names can LET hold?

LET supports up to 126 name-value pairs in a single formula, which is far more than any practical use case requires.

Need a custom variation?

Describe your specific LET problem and get a formula written for your exact data.

Open generator with LET