Expression Language Reference
    Preparing search index...

    Function EXC

    • Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.

      Category: Statistical

      Parameters

      • array: any

        The array or range of data with numeric values that defines relative standing

      • x: any

        The value for which you want to know the rank.

      • significance: any

        Optional. A value that identifies the number of significant digits for the returned percentage value. If omitted, PERCENTRANK.EXC uses three digits (0.xxx).

      Returns number | Error

    Settings

    Member Visibility