Wednesday, February 10, 2021

Use the LET Function in Excel

If you familiar with programming or VBA you'll love the LET function. It basically lets you define a name with a cell, assign it a value and perform calculations with that name. It might be overkill with basic functions, but when you've got more complicated formula that call on the same range or set data ranges, the LET functions makes it more efficient to execute and easier to read and troubleshoot. It's only available on Microsoft 365 version, so if you got that version check out this video to get an introduction to the LET function.

No comments:

Post a Comment