A newer version of this documentation is available.

View Latest

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.