LOGNORM.INV:
Returns the inverse of the lognormal cumulative distribution function of x
Returns the inverse of the lognormal cumulative distribution function of x,
where ln(x) is normally distributed with parameters Mean and Standard_dev. If p = LOGNORM.DIST(x,...) then LOGNORM.INV(p,...) = x.
Use the lognormal distribution to analyze logarithmically transformed data.
The arguments for the LOGNORM.INV function are:
Argument

Required?

Description

probability 
Required 
A probability associated with the lognormal distribution. 
mean 
Required 
The mean of ln(x). 
standard_dev 
Required 
The standard deviation of ln(x). 