Formulas and functions > Functions from A to Z > NORM.S.DIST (standard normal distribution)

Syntax:

NORM.S.DIST(x, cumulative)

Description:

This returns the standard normal (cumulative) distribution function.

The standard normal distribution is a normal distribution (see NORM.DIST/NORMDIST function) with a mean of zero and a standard deviation of 1.

x is the value to be evaluated.

Cumulative determines the type of function as a switch: If you enter the value TRUE, the cumulative distribution function of the standard normal distribution is calculated. By entering the value FALSE, the density function of the standard normal distribution is calculated.

Note:

The NORM.S.DIST function supplements the previous NORMSDIST function with the additional argument Cumulative.

Compatibility notes:

Microsoft Excel supports this function only in version 2010 or later. The function is unknown in older versions.

Note:

The inverse function is NORM.S.INV