LAMBDA

Formulas / LAMBDA
Create custom functions for use throughout a workbook.
=LAMBDA(parameter1, parameter2, ..., calculation)
  • Parameter - a value that is passed to the function
  • Calculation - [REQUIRED for the ASINH function] the formula to be executed and returned as the result of the function

Examples

    This example uses a basic lambda expression to multiply two values together. The expression is written as =x*y and will return the product of the two values.

    This example uses cell references to make a lambda expression. The expression is written as =B5*C5. This expression will return the product of the two values in cells B5 and C5.

    This example uses the lambda syntax to test the syntax of a lambda expression. The expression is written as =LAMBDA(x,y,x*y)(B5,C5). This expression will return the product of the two values in cells B5 and C5.

    This example uses a generic lambda expression to multiply two values. The expression is written as =LAMBDA(x,y,x*y)(B5,C5). This expression will return the product of the two values in cells B5 and C5.

    This example uses the XBYY function to multiply two values in cells B5 and C5. The expression is written as =XBYY(B5,C5). This expression will return the product of the two values in cells B5 and C5.

    This example uses a lambda expression to calculate the volume of a sphere. The expression is written as =

  • 4/3*PI()*A1^3. This expression will return the volume of the sphere.

Summary

LAMBDA functions are custom functions created with a friendly name that can be used to eliminate the need to copy and paste formulas. They are useful tools for non-programmers to perform commonly used formulas.

  • The LAMBDA function allows users to create custom functions that can be used in any cell in a workbook.
  • The ISOMITTED function can be used to create optional arguments in a LAMBDA function.


Frequently Asked Questions

What is a LAMBDA function?
A LAMBDA function is a custom, reusable function that can be called by a friendly name. It is a type of cloud computing service that runs code in response to events and automatically manages the computing resources required by that code.
Who can create a LAMBDA function?
A LAMBDA function can be created by anyone, regardless of their programming experience. It is easy to set up and use, and can be used to quickly create custom functions that can be used in a variety of applications.
What can a LAMBDA function do?
A LAMBDA function can be used to perform a range of tasks, such as running code in response to events, automatically managing computing resources, and creating custom functions. It is a powerful tool for quickly creating custom functions that can be used in a variety of applications.
What are the benefits of using a LAMBDA function?
  • Easy to set up and use
  • No programming experience required
  • Can be used to quickly create custom functions
  • Runs code in response to events
  • Automatically manages computing resources

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