Excel functions / Statistics

NORMSDIST function

The chance of a z-score or less in the standard normal distribution. The older form of NORM.S.DIST.

Syntax

=NORMSDIST(z)

Arguments

When to use it

NORMSDIST is the older form of NORM.S.DIST(z, TRUE): the share of a standard normal distribution below a z-score.

Examples

  1. Below z = 1.96

    ABC
    1z
    21.9697.5%

    In C2: =NORMSDIST(A2) → 97.5%

    Try this example

Common mistakes

NORMSDIST 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 NORMSDIST in the playground

Related functions