LET function

The LET function assigns names to values or intermediate calculations inside a formula, then uses those names in the final calculation. It avoids repeating the same expression, which makes the formula more readable and faster to recalculate.

Example

=LET(total;SOMME(B2:B10);B2/total)

Related concepts

The whole glossary