Returns the standard normal distribution (has a mean of zero and a standard deviation of one).

Use this function in place of a table of standard normal curve areas.

Sample Usage

Syntax – Standard Normal Distribution


The NORM.S.DIST function syntax has the following arguments:

  • Z     Required. The value for which you want the distribution.

  • Cumulative     Required. Cumulative is a logical value that determines the form of the function. If cumulative is TRUE, NORMS.DIST returns the cumulative distribution function; if FALSE, it returns the probability mass function.


  • If z is nonnumeric, NORM.S.DIST returns the #VALUE! error value.

  • The equation for the standard normal density function is:


In order to use the NORM.S.DIST formula, start with your edited Excellentable

Then type in the NORM.S.DIST formula in the area you would like to display the outcome:

By adding the values you would like to calculate the NORM.S.DIST formula for, Excellentable will generate the outcome:


User does not have sufficient privileges to access this Content
Learn More