Functions (all)

NumberIf

Function Name:

NumberIf

Description:

Returns the parameter 2 number if the boolean expression in parameter 1 is True. If the boolean expression is not True, it returns the parameter 3 number.

See Conditional Expressions.

Minimum FH Version:

4.0

No. of Parameters:

3

Return Type:

Number

Parameter 1:

A boolean expression (True or False)

Parameter 2:

A number. The number to return if parameter 1 is True.

Parameter 3:

A number. The number to return if parameter 1 is False.

Examples:

=NumberIf(%INDI.SEX% = "Male",21,17)