LAMBDA (PQL - xl)

This function allows you to create and name custom reusable functions that can be called like any other function

  • Library: PQL \ Spreadsheet \ Logical
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

LAMBDA(OPTIONAL parameter, calculation)

Function Arguments

Name

Description

Type

Optional

parameter

A value that you want to pass to the function, such as a cell reference, string or number. You can enter up to 255 parameters

StringOrNumber

Y

calculation

The formula you want to execute and return as the result of the function. It must be the last argument and it must return a result

String

Comments

This function is the same as the Microsoft Excel 'LAMBDA' function - using the same inputs, logic and outputs.