Recent Posts

Archive

Tags

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

FOLLOW

  • Facebook

CONTACT

ADDRESS

Pleasant Grove, UT

©2017 by Office Newb