This function returns the standard normal cumulative distribution function.

Syntax

NORMSDIST(value)

Arguments

The argument can be any numeric 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 Types

Accepts numeric data. Returns numeric data.

Examples

NORMSDIST(F1)

NORMSDIST(R1C6)

NORMSDIST(1.288) gives the result 0.901127