IIF

Action

Returns one of two values depending on the value of a logical expression.

Syntax

IIF(expression, returnvalue1, returnvalue2 )

Parameters

Expression

Specifies the logical expression that IIF( ) evaluates.

ReturnValue1

If expression evaluates to true, ReturnValue1 is returned by IIF.

ReturnValue2

If expression evaluates to false, ReturnValue2 is returned by IIF.

Returns

ReturnValue1 or ReturnValue2, depending on the expression.

Example

FOR EACH $Element IN $Array

$Total = $Total + IIF($Element = "SomeValue", 10, 99)

NEXT