If Operator
Description:
Returns the
then
value when the if
test is true.Returns the
else
value when the if
test is false. In the expression
if A then B else C
, variables in the sub-expression B
are deemed irrelevant if A
is false
, and variables in the sub-expression C
are deemed irrelevant if A
is true
. note
This function is non-evaluable when the
if
test is non-evaluable. Returns:
Any
Parameters:
Parameter | Data Type | Description |
|---|---|---|
1 | Boolean | The if test. |
2 | Any | The value when true. |
3 | Any | The value when false. |
Examples:
When using functions inside a field, remember the field brackets:
{If MultipleBorrowers Then "Each Borrower" Else "The Borrower"}
Expression | Result |
|---|---|
If true Then "T" Else "F" | "T" |
If false Then "T" Else "F" | "F" |
If false Then ( If true Then "T1" Else "T2" ) Else ( If true then "F1" else "F2" ) | "F1" |
Related Content
-
Logic Functions
Format:
Article,
1 min read