FOLLOW

CONTACT

ADDRESS

Pleasant Grove, UT

©2017 by Office Newb

UdemyNewYearPromo.jpg
PaparazziAd-01.jpg

Microsoft Excel Brand New LET() Function

March 18, 2020

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

 

 

 

Please reload

Recent Posts

Please reload

Archive

Please reload

Tags

Please reload