Going deeper with LAMBDA functions
At this point, I’ve only covered the tip of the iceberg with LAMBDA, but I do have space to delve a bit further. First, we’ll look at incorporating optional arguments into LAMBDA functions. After that, I’ll detail some of the errors and conflicts that can arise when creating and using LAMBDA functions. Then, I’ll introduce the free Advanced Formula Environment, which offers a programming interface for creating complex LAMBDA functions. We’ll also create an XBOXVOLUME custom worksheet function that allows you to pass a two-column, three-row block of cells to the LAMBDA function, which will convert any measurements in feet into inches before computing the cubic volume of a box.
Optional LAMBDA Parameters
Cell F11 of the LAMBDA function worksheet, as shown in Figure 11.22, contains the =LAMBDA(quantity,price,[tax],(price+IF(ISOMITTED(tax),0,price *tax))*quantity) formula, which has an optional [tax] Parameter...
