LET

LogicalMicrosoft 365

Name intermediate results inside a formula — readable and faster.

Syntax

LET(name1, value1, [name2, value2], …, calculation)

How it works

Define names once, reuse them in the final calculation. A repeated sub-expression is computed once, not every time it appears.

Examples

=LET(rate, VLOOKUP(A2, tbl, 2, 0), qty, B2, qty*rate*IF(qty>100, 0.9, 1))

→

Related functions

LAMBDA IF

More Logical functions

AND FALSE IF IFERROR IFNA IFS LAMBDA NOT OR SWITCH TRUE XOR

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.