How To Use LET Function in Excel


The LET function is new function is Excel released in April 2020. The LET function assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula. These names only apply within the scope of the LET function. To use the LET function in Excel, you have to define pairs of name and associated value, and a calculation that uses them all.


= LET (name, name_value, calculation )

LET Function in Excel


name – The first name to assign and it must start with a letter.
name_value – Assign the value to the “name"
calculation – A calculation that use the name within the LET function

Example Explanation

For a instance, we has considered name as “tax" and value assigned to tax is 10%. When this formula is input in cell E6, it will calculate the tax % for the value in D6. Formula in E6 is:

This function is currently in Beta version and available in Office Insider and Office 365 subscribers. If you want to learn more about this function, follow us here

Rate LET Function
User Review
5 (2 votes)
scroll to top