# LET

## Content

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:<ul><li>A calculation that uses all names within the LET function. This must be the last argument in the LET function.</li><li>A second name to assign to a second *name\_value*. If a name is specified, *name\_value2* and *calculation\_or\_name3* become required.</li></ul> |
| *name\_value2* | [Optional] The value that is assigned to *calculation\_or\_name2*. |
| *calculation\_or\_name3*<br> | [Optional] One of the following:<ul><li>A calculation that uses all names within the LET function. The last argument in the LET function must be a calculation.</li><li>A third name to assign to a third *name\_value*. If a name is specified, *name\_value3* and *calculation\_or\_name4* become required.</li></ul> |

## 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))`