Introducing the LET function
The LET function requires at least one Name, which is known as a Variable. Such Names only work within the context of a single cell. This means that you can reuse Variables as much as you like, although it is best to assign Names to input cells that you reference repeatedly. As we have discussed, you can use the New Name dialog box to store a formula in a Name. However, such formulas are often difficult at best to use within formulas that reside in worksheet cells. Conversely, Variables within the LET function can contain text, numbers, or calculations that can then be referenced by Name in the calculation argument. As you’ll see, this can eliminate repetitive calculations in formulas.
Cell G3 of the LET function worksheet contains the =LET(length,C3,width,C4,height,C5,length*width*height) formula and returns 1,000. As shown in Figure 11.13, this is like using Names, but you don’t have to create the Variables in advance – you simply...
