ISOMITTED
Checks if lambda argument is omitted.
- Excel: Not checked yet
- Google Sheets: No equivalent
- Returns: Boolean
Examples
=LAMBDA(x, ISOMITTED(x))(1) Result false
Syntax
ISOMITTED(argument) argument- any required
Related
ARRAY_CONSTRAINTruncates a range to at most the given rows and columns. ARRAYFORMULAEvaluates an expression across a range (this engine already spills, so it is a pass-through for sheets compatibility). ARRAYTOTEXTConverts array to text representation. BYCOLApplies lambda to each column of array. BYROWApplies lambda to each row of array. CHOOSECOLSReturns the specified columns from an array.