LET(name1, name1_value, formula_or_name2 [,name2_value, formula_or_name3])
Returns the result of a formula that can use variables.
|name1||The name of the first variable.|
|name1_value||The value or expression to assign to the first variable.|
|formula_or_name2||The formula that uses the "name1" variable or the name of the second variable|
|name2_value||(Optional) The value or expression to assign to the second variable.|
|formula_or_name3||(Optional) The formula that uses both the "name1" and "name2" variables or the name of the third variable.|
|* This function is only available in Microsoft 365.|
* This function allows you to call the expression by name and for Excel to calculate it once.
* For the Microsoft documentation refer to support.office.com
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top