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.
उपयुक्त आहे का?
कॅरॅक्टर मर्यादा : 250
कमाल कॅरॅक्टर मर्यादा 250 आहे.
तुमच्या प्रतिक्रियेबद्दल धन्यवाद.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.