LOGNORM.INV
Returns the inverse of the lognormal cumulative distribution
Syntax
LOGNORM.INV(probability, mean, standard_dev)
Parameters
- 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)
Example
=LOGNORM.INV(0.039084, 3.5, 1.2)