Combining LET with IF

With many complex calculations, especially those involving one or more IF functions (also, the FILTER function and various lookup functions), the same expression will often be repeated multiple times in a formula. This can result in lengthy and hard-to-read formulas and can also cause performance issues, given that the same (often complex) expression can be calculated multiple times. The LET function allows us to assign names to values and/or calculation results, with those names applying in the scope of a