NORM.DIST function
Summary
Returns the normal cumulative distribution
Syntax
NORM.DIST(x,mean,standard_dev,cumulative)
The NORM.DIST 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, NORM.DIST returns the cumulative distribution function; if FALSE, it returns the probability density 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, NORM.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.
Example
=NORM.DIST(A2,A3,A4,TRUE)
=NORM.DIST(A2,A3,A4,FALSE)
=NORM.DIST(A2,A3,A4,FALSE)