IIF
An if-then statement with capability of returning a third, unique value if condition is null
IF( condition
, then
, else
, when null
)
Tests condition
and returns then
if condition
is true
, else
if condition if false, and a when null
value if null.
Arguments
Output
Outputs then
if condition
is true, else
if condition
is false, and a when null
value if condition
is null.
Example
Last updated