LOGNORM.DIST function
LOGNORM.DIST(X,
Mean, StandardDeviation, IsCumulative) LOGNORM.DIST(X;
Mean; StandardDeviation; IsCumulative)
X
Number or { Number }
The value at which to evaluate the function.
Mean
Number or { Number }
The mean of the natural logarithm of the x parameter.
StandardDeviation
Number or { Number }
The standard deviation of the natural logarithm of the x
parameter.
IsCumulative
Logical or { Logical }
FALSE to calculate the probability density function and TRUE to calculate the cumulative distribution function.
Returns
Number or { Number }
A value for the cumulative distribution function of a lognormal distribution.
Returns a value for the cumulative distribution function of a lognormal distribution.
Example
LOGNORM.DIST(1, 0, 1,
TRUE)LOGNORM.DIST(1; 0;
1; TRUE)
Returns 0.5.