LET
Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula
Syntax
LET(name1, name_value1, [name2, name_value2, ...], calculation)
Parameters
- name1: Required. The first name to assign
- name_value1: Required. The value assigned to name1
- name2: Optional. Additional name to assign
- name_value2: Optional. The value assigned to name2
- calculation: Required. The formula expression that uses the assigned names. Must be the last argument
Example
=LET(x, 5, y, 10, x + y)