LET
Assigns names to calculation results.
LogicalDynamic Arrays & LAMBDALogic & ConditionsModern Excel Functions
What it does
Assigns names to calculation results inside a formula to simplify and speed up complex formulas.
Syntax
LET(name1, value1, [name2, value2], ..., calculation)
Arguments
name1(name) — A variable name.value1(value) — Value assigned to the name.
Examples
Name intermediate results
Compute total with tax using named variables.
FORMULA
=LET(x,A2,y,B2,x*(1+y))
RESULT
120
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Amount | Tax rate |
| 2 | 100 | 0.2 |
| 3 | 80 | 0.1 |