Function IIF

Allows a condition to be checked with branching output

IIF([CHECK_VALUE],[VALUE_TRUE],[VALUE_FALSE])

Parameters

# Type Passing Default Name Description/Comments
1 boolean required n/a CHECK_VALUE The condition to check
2 any required n/a VALUE_TRUE A value to return if parameter 1 is true
3 any required n/a VALUE_FALSE A value to return if parameter 1 is false

Returns

The parameter 2 if parameter 1 is true otherwise parameter 3


Examples

Example of conditional expression

{{IIF(IsValid(CLCODET),"Tenant Found","Tenant Not Found")}}