Please use the form below to provide your feedback. Because your feedback is valuable to us, the information you submit in this form is recorded in our issue tracking system (JIRA), which is publicly available. You can track the status of your feedback using the ticket number displayed in the dialog once you submit the form.

A newer version of this documentation is available.

View Latest

Conditional Functions for Numbers

  • reference
    +

    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.