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.