IIf

Returns the first value if the conditions is true, if the condition is false, the second value is returned(immediate if).

Syntax

IIf(condition, true case, false case)

Example

IIf("oil production rate" in "m3/h" >5.5, 10, 0)