Using the LET function to simplify formulas via programming concepts

- [Instructor] In Excel, there's a relatively new … function called LET. … It's particularly useful … if you use nested if functions or nested ifs functions. … And in this particular workbook here, we've got higher date … in column B. … We're trying to come up with some kind … of a tenure based on what we're seeing in this blue box. … So if the number of days someone has been here is … over 6,000 days, it's going to be level five. … If not, we'll check to see if it's … over 5,000 days, level four, and so on and so on and so on. … And these formulas are set up in column D. … Now for reference purposes, … what I've done in column E here, and I'll double click … on cell E too, … is simply use a function called formula texts. … It's displaying the formula … out of cell D2, doing this for reference purposes. … I tend to use this function a lot for documentation. … You're less likely to use it as often. … Now that's a long entry there. … I'm going to jump into cell D2 … by double clicking and there we see it again. …