Technical requirements
The IF, CHOOSE, and PRODUCT functions, as well as Names, work in any version of Excel. The SWITCH function requires Excel 2019 or later, while the LET function requires Excel 2021 or Microsoft 365. The LAMBDA function works in Microsoft 365 and Excel for the web. There are two example workbooks for this chapter: the Chapter 11 - Names, LET, and LAMBDA.xlsx workbook can be opened in any version of Excel, although SWITCH, LET, and LAMBDA will return #NAME? in unsupported versions of Excel. The Chapter 11 - BOX_VOLUME and XBOX_VOLUME.xlsm workbook contains programming code used to create custom worksheet functions and may be blocked by your network or Microsoft Windows. I’ll show you how to resolve a Windows block when we get to that part of this chapter. Both workbooks can be downloaded from GitHub at https://github.com/PacktPublishing/Exploring-Microsoft-Excels-Hidden-Treasures/tree/main/Chapter11.
