- Formula Reference
- Contacting Us
- Getting Technical Support
- Formula Overview
-
Formula Functions
- Functions A to C
- Functions D to G
-
Functions H to L
- HARMEAN
- HBARSPARKLINE
- HEX2BIN
- HEX2DEC
- HEX2OCT
- HISTOGRAMSPARKLINE
- HLOOKUP
- HOUR
- HSTACK
- HYPERLINK
- HYPGEOM.DIST
- HYPGEOMDIST
- IF
- IFERROR
- IFNA
- IFS
- IMABS
- IMAGE
- IMAGINARY
- IMARGUMENT
- IMCONJUGATE
- IMCOS
- IMCOSH
- IMCOT
- IMCSC
- IMCSCH
- IMDIV
- IMEXP
- IMLN
- IMLOG10
- IMLOG2
- IMPOWER
- IMPRODUCT
- IMREAL
- IMSEC
- IMSECH
- IMSIN
- IMSINH
- IMSQRT
- IMSUB
- IMSUM
- IMTAN
- INDEX
- INDIRECT
- INFO
- INT
- INTERCEPT
- INTRATE
- IPMT
- IRR
- ISBLANK
- ISERR
- ISERROR
- ISEVEN
- ISFORMULA
- ISLOGICAL
- ISNA
- ISNONTEXT
- ISNUMBER
- ISO.CEILING
- ISODD
- ISOMITTED
- ISOWEEKNUM
- ISPMT
- ISREF
- ISTEXT
- JIS
- KURT
- LAMBDA
- LARGE
- LCM
- LEFT
- LEFTB
- LEN
- LENB
- LET
- LINEST
- LINESPARKLINE
- LN
- LOG
- LOG10
- LOGEST
- LOGINV
- LOGNORM.DIST
- LOGNORM.INV
- LOGNORMDIST
- LOOKUP
- LOWER
- Functions M to Q
- Functions R to S
- Functions T to Z
ISOMITTED
This function checks whether the value in a LAMBDA is missing and returns TRUE or FALSE.
Syntax
ISOMITTED(argument)
Arguments
Specify a value you want to test, such as a LAMBDA parameter.
Data Types
Returns TRUE or FALSE
Examples
ISOMITTED(a)
LAMBDA(x,y, IF(ISOMITTED(y),"Missing second argument",x+y))(1,)
Version Available
This function is available in product version 15 or later.