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)
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