[]
DEMOS DOCS API PRICING
FREE TRIAL
(Showing Draft Content)

LET

This function assigns names to calculation results.

Syntax

LET(name1, name_value1, calculation_or_name2, [name_value2, calculation_or_name3...])

Arguments

Argument

Description

name1

[Required] The first name to assign. Must start with a letter. Cannot be the output of a formula or conflict with range syntax.

name_value1

[Required] The value that is assigned to name1.

calculation_or_name2

[Required] One of the following:

  • A calculation that uses all names within the LET function. This must be the last argument in the LET function.

  • A second name to assign to a second name_value. If a name is specified, name_value2 and calculation_or_name3 become required.

name_value2

[Optional] The value that is assigned to calculation_or_name2.

calculation_or_name3


[Optional] One of the following:

  • A calculation that uses all names within the LET function. The last argument in the LET function must be a calculation.

  • A third name to assign to a third name_value. If a name is specified, name_value3 and calculation_or_name4 become required.

Remarks

  • The last argument must be a calculation which returns a result.

  • Names of variables align with valid names that can be used in the name manager. E.g. "a" is valid but "c" is not because it conflicts with R1C1 style references.

Examples

LET(x, 5, SUM(x, 1))