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.