ISOMITTED

Formulas / ISOMITTED
Check if a LAMBDA has a missing argument.
FALSE
  • The argument - the value to test

Examples

    This example shows how ISOMITTED can be used to determine if an argument is missing from a function call. =LAMBDA(x,y, IF(ISOMITTED(y),"Missing second argument",x+y))(1,) returns the value of x if y is missing, and the string “Missing second argument” if y is included.

Summary

The ISOMITTED function checks if a value in a LAMBDA is missing and returns TRUE or FALSE accordingly. It is a useful tool for verifying the presence of data in a LAMBDA.

  • The ISOMITTED function will return a friendly string if the value in a LAMBDA is not present.
  • The argument for the ISOMITTED function is the value to be tested.


Frequently Asked Questions

What is the ISOMITTED function?
The ISOMITTED function is used to check for missing values in the LAMBDA language. It returns TRUE if a value is missing, FALSE if the value is not missing, and a friendly string if a value is missing.
What values does the ISOMITTED function return?
The ISOMITTED function returns TRUE if a value is missing, FALSE if the value is not missing, and a friendly string if a value is missing.
How do I use the ISOMITTED function?
The ISOMITTED function can be used in LAMBDA by passing in a value as an argument. The function will then return TRUE if the value is missing, FALSE if it is not missing, and a friendly string if the value is missing.
What are some examples of the ISOMITTED function?
  • If you are checking for a missing value in a LAMBDA variable, you can use the ISOMITTED function like so:
    • ISOMITTED(my_variable)
  • If you are checking for a missing value in a LAMBDA array, you can use the ISOMITTED function like so:
    • ISOMITTED(my_array[i])
    • What are the advantages of using ISOMITTED?
    The ISOMITTED function is a concise and easy way to check for missing values in the Lamda function

    Related Functions

    Sourcetable Logo

    Work smarter

    Al is here to help. Leverage the latest models to
    analyze spreadsheets, enrich data, and create reports.

    Drop CSV