LET function in Excel

LET names intermediate results inside one formula.

Syntax

=LET(name1, value1, …, calculation)

Argument	Required?	What it is
name1	Required	A name for the first value, used later in the formula.
value1	Required	The first value, cell or range.
calculation, …	Required	The final formula, which can use every name defined before it.

=LET(total,SUM(C2:C10),bonus,total*5%,total+bonus)

From the lesson LET Function.

Type the formula yourself and get it graded instantly, no Excel needed.

LET names intermediate results inside one formula.

=LET(name1, value1, …, calculation)

Argument	Required?	What it is
name1	Required	A name for the first value, used later in the formula.
value1	Required	The first value, cell or range.
calculation, …	Required	The final formula, which can use every name defined before it.

=LET(total,SUM(C2:C10),bonus,total*5%,total+bonus)

From the lesson LET Function.

Type the formula yourself and get it graded instantly, no Excel needed.