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.