LAMBDA

The LAMBDA function allows you to define a sub-formula that accepts up to 253 parameters as input.

LAMBDA(parameter, parameter…, calculation)

parameter: An input that defines the value you are passing through the formula.

parameter…: Optionally include one or more additional parameters.

calculation: The formula you want the function to execute and return. This is required and must be the last argument.

Notes

  • LAMBDA allows you to define values that are represented as formula tokens. Once defined, they can appear in type-ahead and used elsewhere in the function.

  • If you only input a LAMBDA function into a cell, it returns an error. In order to test the LAMBDA function and return a value, use the LAMBDA.APPLY function. See the examples below.

  • When an Excel spreadsheet containing LAMBDA functions is imported into Numbers, each formula referencing a LAMBDA function receives a local copy of the definition.

  • Use the LAMBDA.APPLY function when testing a LAMBDA function imported from Excel.

  • LAMBDA functions can be used and referenced only in the cell in which they are defined.

  • LAMBDA functions cannot be nested.

Examples

Suppose you want to test a LAMBDA function that converts a temperature from Fahrenheit to Celsius, and you have a temperature value in cell A1.

=LAMBDA.APPLY(A1, LAMBDA(temp, (temp-32)*5/9)).

See alsoLAMBDA.APPLYISOMITTED
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.