Please note javascript is required for full website functionality.

Blog

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))

was provided earlier, 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 arg2I’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.

Newsletter