LET() assigns names to calculations in Excel
Let() is a new function in Windows and Mac versions of Excel 365 and Excel 2021 (plus Excel Online) which is popular with makers of long, complicated functions. The function lets you name a temporary variable to use within a formula. That might seem a strange thing to do but it’s a godsend for advanced […]