The if function returns a value depending on whether the condition provided with the function evaluates as True or False.
Syntax:
if(condition , then [, else])
The if function has three parameters, condition, then and else, which are all expressions. The two other ones, then and else, can be of any type.
Arguments:
| Argument | Description |
|---|---|
| condition | Expression that is interpreted logically. |
| then | Expression that can be of any type. If the condition is True, then the if function returns the value of the then expression. |
| else |
Expression that can be of any type. If the condition is False, then the if function returns the value of the else expression. This parameter is optional. If the condition is False, NULL is returned if you have not specified else. |
Examples and results:
| Example | Result |
|---|---|
|
if( Amount>= 0, 'OK', 'Alarm' ) |
This expression will test if the amount is a positive number (0 or larger) and return 'OK' if it is. If the amount is less than 0, 'Alarm' is returned. |
