IFS (PQL - xl)
This function performs a comparison and returns the specified associated value if comparison is TRUE
- Library: PQL \ Spreadsheet \ Logical
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
IFS(logical test, value if true)
Function Arguments
Name | Description | Type | Optional |
logical test | Refers to a value or expression to evaluate | StringOrNumber |
|
value if true | Refers to a value to return if the test evaluates to true | StringOrNumber |
|
Comments
This function is the same as the Microsoft Excel 'IFS' function - using the same inputs, logic and outputs.