LET (PQL - xl)

This function is used to assign names to calculation results. The variable names can then be used to store intermediate calculations, values, or defining names within braces of the LET() function. To use this function, you have to define pairs of names and values associated with it, and a calculation that uses them all

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

Syntax

LET(name, name value, calculation or name)

Function Arguments

Name

Description

Type

Optional

name

First name to assign. Must always begin with a letter and should not contain a

String

name value

The value that is assigned to name1

StringOrNumber

calculation or name

You can define one of the following: a calculation that uses all names within the LET function. This must be the last argument in the LET function, or a second name to be assigned to a second name value. If a name is specified, name value2 and calculation or name3 become required

StringOrNumber

Comments

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