[]
This function returns the inverse of the lognormal cumulative distribution function of x, where LN( x ) is normally distributed with the specified mean and standard deviation.
LOGNORM.INV(prob, mean, stdev)
This function has these arguments:
Argument | Description |
---|---|
prob | Value at which to evaluate the function |
mean | Value of mean of the natural logarithm of x, LN(x) |
stdev | Value representing the standard deviation of LN(x) |
This function calculates the inverse of the lognormal cumulative distribution functions, so if p = LOGNORM.DIST( x, ...) then LOGNORM.INV( p ,...) = x . The #VALUE! error value is returned if any argument is non-numeric.
Accepts numeric data for all arguments. Returns numeric data.
LOGNORM.INV(0.92,B8,G22)
LOGNORM.INV(0.88,2,1.2)
gives the result 30.264764580330958