Optimize your formulas with the LET function
The LET function allows you to optimize the formulas in your workbook.
LET allows you to convert functions into variables and reuse these variables to free up your computer's memory.
Formula to get a date from a week number https://www.excel-exercice.com/calcul...
LET function to display a number in words https://www.excel-exercice.com/conver...
00:00 Introduction to the LET function
00:23 Analyzing a formula with VLOOKUP
01:32 How to build the LET function
03:23 Optimizing the week formula with LET
05:05 Improving the LET function
05:46 Conclusion