LogicalLevel: ExpertAvailable in: Excel 365 / 2021+

LET assigns names to calculations inside a formula, so long formulas become readable and repeated parts are calculated once.

Syntax

=LET(name1, value1, [name2, value2, ...], calculation)

Examples

Example 1

=LET(total, SUM(B2:B13), IF(total>100000, total*0.9, total))

Discount only on large totals; SUM runs once.

Power combo

=LET(n, A2, first, TEXTBEFORE(n," "), last, TEXTAFTER(n," ",-1), last&", "&first)

“Asha Kumari Verma” → “Verma, Asha”.

Related functions

LAMBDA · IF · FILTER

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.