LAMBDA: Create Functions Includes Percent Difference and ISOMITTED
One in a series on dynamic array functions in Excel. This one demonstrates how to use LAMBDA to create your own functions. Create a simple SUBTRACT LAMBDA, a percentage difference LAMBDA and use LAMBDA with ISOMITTED to detect missing arguments.