LET function

Category: Logical
Introduced: Excel 2021

Summary

Assigns names to calculation results

Syntax

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

Example

=LET(x, 5, SUM(x, 1))
=IF(ISBLANK(FILTER(A2:D8,A2:A8="Fred")),"-", FILTER(A2:D8,A2:A8="Fred"))
=LET(filterCriteria,"Fred", filteredRange, FILTER(A2:D8,A2:A8=filterCriteria), IF(ISBLANK(filteredRange),"-", filteredRange))

Microsoft Support Page

https://support.microsoft.com/en-us/office/let-function-34842dd8-b92b-4d3f-b325-b8b8f9908999

Back to Functions