LOGNORM.INV function
LOGNORM.INV(Probability, Mean, StandardDeviation)
LOGNORM.INV(Probability; Mean; StandardDeviation)
Probability
Number or { Number }
A probability associated with the lognormal distribution.
Mean
Number or { Number }
The mean of the natural logarithm of the probability parameter.
StandardDeviation
Number or { Number }
The standard deviation of the natural logarithm of the probability parameter.
Returns
Number or { Number }
The inverse of the LOGNORM.DIST function.
Returns the inverse of the LOGNORM.DIST function.
Example
LOGNORM.INV(0.5, 0,
1)LOGNORM.INV(0,5; 0;
1)
Returns 1.