NORMSDIST

Name

Standard normal distribution

Description

Returns the standard normal cumulative distribution function.

Syntax

NORMSDIST(value)

Remarks

The 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.

Data Type

Accepts numeric data. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

NORMSDIST(F1)
NORMSDIST(R1C6)
NORMSDIST(1.288)=0.901127