Termin Excela

LET Function

The LET function assigns names to calculation results, allowing you to store intermediate values within a formula.

Co oznacza LET Function

LET improves formula readability and performance by allowing you to define variables that can be reused multiple times. Instead of repeating complex logic, you assign it a name once and reference that name throughout the rest of the formula.

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

Przykład

Calculate a 10% tax on a total: =LET(subtotal, 100, tax, 0.1, subtotal * (1 + tax))

Najczęstsze pytania

Why use LET instead of a standard formula?

LET makes complex formulas easier to read, debug, and faster to calculate by avoiding redundant operations.

Powiązane terminy

LAMBDA Function