ISOMITTED

The ISOMITTED function determines if the parameter in a LAMBDA function has been passed to the LAMBDA.APPLY function, and returns TRUE or FALSE.

ISOMITTED(parameter)

parameter: The value to test.

Examples

You can use ISOMITTED in combination with IF to return a phrase indicating whether or not the value is missing.

If cell A1 contains 70, a Fahrenheit temperature value to be converted to Celsius:

=LAMBDA.APPLY( , LAMBDA(temp, IF(ISOMITTED(temp), "value is missing", (temp−32)×5÷9))) returns “value is missing” because A1 has not been passed to the LAMBDA.APPLY function, so LAMBDA has no value to reference for “temp.”

=LAMBDA.APPLY(A1, LAMBDA(temp, IF(ISOMITTED(temp), “value is missing”, (temp−32)×5÷9))) returns “21.11…” because the temperature is not omitted.

See alsoLAMBDALAMBDA.APPLY
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Uporabno?
Omejitev znakov: 250
Zgornja omejitev znakov je 250.
Hvala za povratne informacije.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.