LAMBDA Function in Google Sheets

Create custom functions in Google Sheets using the LAMBDA function.

LAMBDA Function

The LAMBDA function in Google Sheets allows you to create custom, reusable functions using a formula expression.

Syntax

LAMBDA(name, formula_expression)

Examples

  1. Create a Simple LAMBDA Function

Define a custom function to add 10 to a number:

=LAMBDA(x, x + 10)(5)

This will output 15.

  1. Use LAMBDA in Named Functions

Create a reusable function for multiplying two numbers:

=LAMBDA(a, b, a * b)

You can then use this function in the spreadsheet by referencing it with the appropriate parameters.

Notes

  • The LAMBDA function is powerful for simplifying repetitive tasks and creating complex formulas.
  • It can be combined with other functions to create versatile custom tools.
  • LET: Assign names to calculation results for use within a formula.
  • ARRAYFORMULA: Applies a function to a range of cells.