Excel LET function | ExceljetPublished byexceljet.neton •1 min readThe LET function lets you define named variables in a formula. There are two primary reasons you might want to do this: (1) to improve performance by eliminating redundant calculations and (2) to make more complex formulas easier to read and write.Excel 2021Dynamic arrayby Dave Bruns · Updated 11 Dec 2025Related functionsPurpose Assign variables inside formulaPurposeReturn value Normal formula resultReturn valueSyntaxUsing the LET functionFunctionsLearn moreShareLegalReport