NORM.S.DIST function
Summary
Returns the standard normal cumulative distribution
Syntax
For a standard normal distribution, this is the syntax:
NORM.S.DIST(z,cumulative)
This function syntax uses the following arguments:
• z Required. This is the value for which you want the distribution.
• cumulative Required. The cumulative argument can be either TRUE or FALSE. This logical value determines the form of the function. If cumulative is TRUE then NORM.S.DIST returns the cumulative distribution function. If it is FALSE, it returns the probability mass function.
This function syntax uses the following arguments:
• z Required. This is the value for which you want the distribution.
• cumulative Required. The cumulative argument can be either TRUE or FALSE. This logical value determines the form of the function. If cumulative is TRUE then NORM.S.DIST returns the cumulative distribution function. If it is FALSE, it returns the probability mass function.
Example
=NORM.S.DIST(1.333333,TRUE)
=NORM.S.DIST(1.333333,FALSE)
=NORM.S.DIST(1.333333,FALSE)