LOGNORM.DIST function
Summary
Returns the cumulative lognormal distribution
Syntax
LOGNORM.DIST(x,mean,standard_dev,cumulative)
The LOGNORM.DIST function syntax has the following arguments:
• X Required. The value at which to evaluate the function.
• Mean Required. The mean of ln(x).
• Standard_dev Required. The standard deviation of ln(x).
• Cumulative Required. A logical value that determines the form of the function. If cumulative is TRUE, LOGNORM.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.
• X Required. The value at which to evaluate the function.
• Mean Required. The mean of ln(x).
• Standard_dev Required. The standard deviation of ln(x).
• Cumulative Required. A logical value that determines the form of the function. If cumulative is TRUE, LOGNORM.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.
Example
=LOGNORM.DIST(A2,A3,A4,TRUE)
=LOGNORM.DIST(A2,A3,A4,FALSE)
=LOGNORM.DIST(A2,A3,A4,FALSE)