Summary

This chapter led you down a path that started with computing the cubic volume of a box with simple multiplication. Then, we layered on more and more complexity as we made our way to the LET and LAMBDA functions. The phrase game-changing often feels trite, but if you write complex formulas in Excel, both LET and LAMBDA empower you to write formulas today that you won’t cringe at when you see them again in the future. I’ve thought “what planet was I on that day?” more than a few times throughout my career when revisiting formulas that span multiple rows in the Formula Bar area.

We made several stops, including visiting functions such as PRODUCT, IF, CHOOSE, and SWITCH. I included these because of similarities in how you can pass information to the functions, or swap information around as stepping-stones toward LET and LAMBDA. From there, we embarked on creating Names, partly to correlate the similarities between the LET and LAMBDA functions, but...