ISOMITTED function

This is a logical function used as an argument by the LAMBDA function, and it aims to check if any of the arguments have been omitted. When using the LAMBDA function, it is mandatory to provide as many arguments as initially given. Since it returns the value TRUE or FALSE it is used in combination with the IF function in the part of the LAMBDA function where it is necessary to specify the value it returns.

The syntax of this function is:

ISOMITTED (<argument>)

In the example we have a table with item names, quantities, prices and amounts to be calculated as product quantity and price. If we enter the formula:

=LAMBDA(x,y,IF(ISOMITTED(x),”Enter quantity”,x*y))(B2,C2)

Excel will check that both arguments are given. In this case they are, and the amount is calculated as the product of quantity and price. That by some chance we entered:

=LAMBDA(x,y,IF(ISOMITTED(x),”Enter quantity”,x*y))(,C2)

Excel would recognize this as an omission of the first argument and would send a message that the quantity needs to be entered.