Logical Excel 2021 ◉ 33 views

=LET()

LET function

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for Mac

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

Hover argument names in the table for details.

Output typeMixed

Popularity60 / 100

VolatileNo

Dynamic ArrayNo

Download sample .xlsx ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas

⬇ Download Sample Workbook

A dedicated .xlsx for =LET() with Persian sample data & live formulas — open in Excel and practice.

Download LET.xlsx ~ 8–12 KB · No macros

%d questions — syntax, example & errors — test yourself!

Start quiz →

Argument	Type	Required	Description
`name1`	Any type	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`	Any type	Required	The value that is assigned to name1.
`calculation_or_name2`	Any type	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
`name_value2`	Any type	Optional	The value that is assigned to calculation_or_name2.
`calculation_or_name3`	Any type	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

▦ Data

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

🔒 Your comment will be published after review.

Share your thoughts — visible after admin approval

No comments yet — be the first!