Conditional Functions for Numbers

Conditional functions evaluate expressions to determine if the values and formulas meet the specified condition.

IFINF(expression1, expression2, ...)

Returns first non-MISSING, non-Inf number. Returns MISSING or NULL if a non-number input is encountered first.

IFNAN(expression1, expression2, ...)

Returns first non-MISSING, non-NaN number. Returns MISSING or NULL if a non-number input is encountered first.

IFNANORINF(expression1, expression2, ...)

Returns first non-MISSING, non-Inf, or non-NaN number. Returns MISSING or NULL if a non-number input is encountered first.

NANIF(expression1, expression2)

Returns NaN if expression1 = expression2, otherwise returns expression1. Returns MISSING or NULL if either input is MISSING or NULL.

NEGINFIF(expression1, expression2)

Returns NegInf if expression1 = expression2, otherwise returns expression1. Returns MISSING or NULL if either input is MISSING or NULL.

POSINFIF(expression1, expression2)

Returns PosInf if expression1 = expression2, otherwise returns expression1. Returns MISSING or NULL if either input is MISSING or NULL.