LOGNORM.INV
Description
Returns the inverse of the log-normal cumulative distribution function of x, where ln(x) is
normally distributed with parameters mean and standard deviation.
Syntax
LOGNORM.INV(
probability
,
mean
,
standard_dev
)
- probability: The probability associated with the log-normal distribution.
- mean: The mean of ln(x).
- standard_dev: The standard deviation of ln(x).
Example
Formula | Result |
|---|---|
=LOGNORM.INV(0.039084, 3.5, 1.2) | 4.000025219 |
Notes
- This function does the same action as LOGNORMINV() and LOGINV().