ISOMITTED Function

Description

Checks whether the input argument in a Lambda function is missing and returns TRUE or FALSE.  

NOTES

• This function can only be used inside custom Lambda functions.
• To make use of optional parameters, just wrap the optional name in “[ ]”.

Syntax

Copied!=ISOMITTED(argument)
=ISOMITTED(argument)

EXAMPLE

Copied!//𝘥𝘦𝘧𝘪𝘯𝘦 𝘢 𝘭𝘢𝘮𝘣𝘥𝘢 𝘧𝘶𝘯𝘤𝘵𝘪𝘰𝘯 𝘧𝘹
=LAMBDA(x, [y], IF(ISOMITTED(y), x, x+y))

fx(1) = 1
fx(2) = 2
fx(1,2) = 3
//𝘥𝘦𝘧𝘪𝘯𝘦 𝘢 𝘭𝘢𝘮𝘣𝘥𝘢 𝘧𝘶𝘯𝘤𝘵𝘪𝘰𝘯 𝘧𝘹
=LAMBDA(x, [y], IF(ISOMITTED(y), x, x+y))

fx(1) = 1
fx(2) = 2
fx(1,2) = 3

RELATED