NORMDIST function
Summary
Returns the normal cumulative distribution
Syntax
NORMDIST(x,mean,standard_dev,cumulative)
The NORMDIST function syntax has the following arguments:
• X Required. The value for which you want the distribution
• Mean Required. The arithmetic mean of the distribution
• Standard_dev Required. The standard deviation of the distribution
• Cumulative Required. A logical value that determines the form of the function. If cumulative is TRUE, NORMDIST returns the cumulative distribution function; if cumulative is FALSE, it returns the probability mass function.
• X Required. The value for which you want the distribution
• Mean Required. The arithmetic mean of the distribution
• Standard_dev Required. The standard deviation of the distribution
• Cumulative Required. A logical value that determines the form of the function. If cumulative is TRUE, NORMDIST returns the cumulative distribution function; if cumulative is FALSE, it returns the probability mass function.
Example
=NORM.DIST(A2,A3,A4,TRUE)
=NORM.DIST(A2,A3,A4,FALSE)
=NORM.DIST(A2,A3,A4,FALSE)