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