iif

Function: (Miscellaneous)
Description: Evaluate an expression depending on condition
Usage: Iif(condn, qtyIfTrue, qtyIfFalse)

Details

Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE.

Use Iif() to perform conditional tests on values and expression.

Parameters

condn = logical expression
qtyIfTrue
= expression if true
qtyIfFalse
= expression if false

Example

Iif(ft.<m., 1, 0) will return 1
Iif(ft.==m., 1, 0) will return 0