LET
Description
The LET function is intended for use in larger workbooks where you want to minimize
calculation time. LET allows you to create and use variables in your formulas,
reducing the number of times a part of a formula is calculated..
Syntax
LET(
name1
,
name_value1
,
calculation_or_name2
, [
name_value2
,
calculation_or_name3
, ...])
- name1: The first variable name.
- name_value1: The value of the first variable. The value can be a cell, a range, or the result of a function or formula. Arrays are allowed.
- calculation_or_name2: The calculation to perform using the variable, or, a second variable name.
- name_value2: The value of the second variable. The value can be a cell, a range, or the result of a function or formula. Arrays are allowed.
- calculation_or_name3: The calculation to perform using the variable, or, a third variable name.
- name_value3: The value of the third variable. The value can be a cell, a range, or the result of a function or formula. Arrays are allowed. You can have more than 3 variables.