If Function

The If function returns one of two values, depending on a given condition.

Syntax

If(condition, returnTrueValue, returnFalseValue)

The If function returns one of two values, depending on a given condition.

Arguments

condition Boolean - The condition.

returnTrueValue Any - The value to return when the condition is true.

returnFalseValue Any - The value to return when the condition is false.

Remarks

Example:

If(BI_PD.Premium < 10000, 10000, BI_PD.Premium); // returns 10000