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
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.