LET Function in Excel: Syntax, Examples and Free Practice
LET is an Excel Logic function. Assigns names to calculation results, so a formula can reuse them.
LET syntax
Arguments
name1: A name to assign to a value, reused later in the formulavalue1: The first valuename2: An additional name to assign (optional)value2: An additional value (optional)calculation: The formula to run using the names defined earlier in LET
When to use LET
LET is used to build decision rules directly into a spreadsheet instead of manually judging each row.
Practice LET online, free
Open the live Excel-style spreadsheet and try LET yourself. No Excel install or sign-up needed to start.
Practice LET now →More Logic functions
Frequently asked questions
What does the LET function do in Excel?
Assigns names to calculation results, so a formula can reuse them.
What is the syntax of LET in Excel?
The syntax is =LET(name1, value1, [name2, value2, ...], calculation). name1: A name to assign to a value, reused later in the formula; value1: The first value; name2: An additional name to assign (optional); value2: An additional value (optional); calculation: The formula to run using the names defined earlier in LET.
Where can I practice LET online for free?
Open the free live spreadsheet on Cellgrids and try LET yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Logic functions · Excel case studies · Excel tutorials · Excel shortcuts