Home

Microsoft Excel Brand New LET() Function Microsoft just released a new Excel function called LET(). The LET() function allows users to associate a value or calculation with a name/variable. LET() FUNCTION DEFINITION =LET(name1, value1, [name2...], [value2...], calculation) BENEFITS

• LET() allows users to potentially create cleaner more readable formulas by eliminating redundant references and adding additional context to values
• By removing redundant expressions in a formula users can gain better performance

Download the exercise file used in the video to follow along: EXCEL-LET-FUNCTION-01.XLSX