LOGNORM.INV (Probability, Mean, StandardDeviation) LOGNORM.INV (Probability; Mean; StandardDeviation)
Probability
Number Number
A probability associated with the lognormal distribution.
Mean
Number Number
The mean of the natural logarithm of the values of the distribution.
StandardDeviation
Number Number
The standard deviation of the natural logarithm of the values of the distribution.
Returns the inverse of the cumulative LOGNORM.DIST function. Given a probability, this function returns the value at which the cumulative lognormal distribution equals that probability.
Example
LOGNORM.INV (0.5, 0, 1)
LOGNORM.INV (0,5; 0; 1)
Returns 1.