A to Z of Excel Functions: The ISOMITTED Function
12 August 2021
Welcome back to our regular A to Z of Excel Functions blog. Today we look at the ISOMITTED function.
The ISOMITTED function
This new function checks whether the value is missing, and returns either TRUE (value is missing) or FALSE (value is not missing) accordingly. The syntax is simple:
ISOMITTED(argument)
where:
- argument is a required parameter, and is the value you want to test, which may be based upon a LAMBDA.
The example
=LAMBDA(arg1, [arg2], IF(ISOMITTED(arg2), arg1, arg2))
is where this lambda will return the value of arg1 if arg2 is omitted (this is why arg2 is in square brackets as it is an optional argument); otherwise, it will return the value of arg2.
Simply put, this lambda will return the value of arg1 if arg2 is omitted; otherwise, it will return the value of arg2. I’d like to have called this lambda function Jason as it sort of checks if his args are naught, but sadly it’s not Friday 13th…
We’ll continue our A to Z of Excel Functions soon. Keep checking back – there’s a new blog post every other business day.
A full page of the function articles can be found here.
