Excel NORMSDIST function

The Excel NORMSDIST function returns the standard normal cumulative distribution function (CDF). This is a legacy function that is replaced by the NORM.S.DIST function, which returns both the CDF and probability density function (PDF). For complete documentation and examples, see the NORM.S.DIST function.

Purpose

Calculate the standard normal cumulative distribution function (CDF) for a given z-score.

Return value

A number between 0 and 1 representing the cumulative probability.

Syntax

=NORMSDIST(z)

z - Numeric z-score value.

Using the NORMSDIST function

The NORMSDIST function returns values for the standard normal cumulative distribution function (CDF). The function expects standardized input in the form of a z-score value, which represents how far a value is from the mean of a distribution in terms of the standard deviation.

For better accuracy and consistency with other modern statistical functions, it is recommended to use the NORM.S.DIST function. NORM.S.DIST provides the same CDF functionality with improved numerical precision, plus the additional ability to return the probability density function (PDF) when the cumulative argument is set to FALSE. See the NORM.S.DIST function for more details.