IF
Tests if the first argument is set (1/true) and if so, returns the second argument, else the third
Example Usage
IF(IS_SET(PayDate), PayDate, PunchTime) // if PayDate has a value, use it, otherwise use PunchTime
Overview
Function signature
IF(condition, yesresult, noresult)
Category
Logical
Return data type
None
Arguments
| Name | DataType | List Options | Description |
|---|---|---|---|
condition | None | The condition/value to check if set (1/true) | |
yesresult | None | The value to return if condition is set (1/true) | |
noresult | None | The value to return if the condition is not set (0/false) |