Excel’s LET function is the most underrated thing in the entire program
If you’ve spent any time writing formulas in Excel, you’ve likely written that one long formula like a sentence that never ends. These formulas may work, but they’re long, complicated, and if someone other than you needs to replicate them, they’re not going to have a good time understanding what’s going on. However, problems like this shouldn’t exist, especially considering Excel can now write its own formulas. But if you don’t trust Excel, or simply prefer to write your own formulas, the LET function is here to help you out. Related This Excel Trick Lets Me Write Formulas Like a Human Smarter Excel formulas with the simplicity of everyday language. This function changes how Excel formulas work What LET actually does—and why it matters Image taken from Microsoft Excel support page.Credit: Microsoft The LET function is built for one simple function, and if you’ve ever written code before, you can probably guess what it is: it lets you name things inside a formula. You give a value or calculation a name, and then you can use …
