NORM.S.DIST function

NORM.S.DIST(x, isCumulative) NORM.S.DIST(x; isCumulative)

x — Number or { Number }

A value at which to evaluate the function.

isCumulative — Logical or { Logical }

FALSE to calculate the probability mass function and TRUE to calculate the cumulative distribution function.

Returns — Number or { Number }

A value for the cumulative distribution function of a normal distribution.

Returns a value for the cumulative distribution function of a normal distribution.

Examples

NORM.S.DIST(1, FALSE)NORM.S.DIST(1; FALSE)

Returns roughly 0.2.

NORM.S.DIST(1, TRUE)NORM.S.DIST(1; TRUE)

Returns roughly 0.8.