In This Topic

NORM.S.DIST

In This Topic

This function returns the standard normal cumulative distribution function.

NORM.S.DIST(*value,cumulative*)

This function has these arguments:

Argument | Description |
---|---|

value |
A numeric value for which you want the distribution |

cumulative |
A logical value that determines the form of the function. If cumulative is TRUE, the function returns the cumulative distribution function; if FALSE, it returns the probability mass function |

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.

If *value* is nonnumeric, the #VALUE! error value is returned.

Accepts numeric data for *value*. Accepts TRUE or FALSE for *cumulative.* Returns numeric data.

NORM.S.DIST(F1,TRUE)

NORM.S.DIST(R1C6,TRUE)

NORM.S.DIST(1.288,TRUE) gives the result 0.901127

This function is available in Spread for Windows Forms 11.0 or later.