Excel functions / Statistics

PROB function

Adds up the probabilities of the outcomes that fall between two limits.

Syntax

=PROB(x_range, prob_range, lower_limit, [upper_limit])

Arguments

When to use it

PROB adds up the probabilities of the outcomes that fall between two limits, given a list of outcomes and the chance of each.

Examples

  1. Chance of 1 to 3

    ABCD
    1OutcomeChance
    200.20.8
    310.3
    420.1
    530.4

    In D2: =PROB(A2:A5, B2:B5, 1, 3) → 0.8

    Try this example

Common mistakes

PROB in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try PROB in the playground

Related functions