Between the Sheets — Excel podcast episode 45: using the Let function
In partnership with Experts Exchange. Introduced in the 365 editions of Excel, the Let function lets you define variables, their values and calculations that use them, then use these to simplify complicated formulas. When you have a long formula that repeats a calculation several times, like an If function, Let