LOGNORM.INV function

The LOGNORM.INV function is one of the statistical functions. It is used to return the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard_dev.

Syntax

LOGNORM.INV(probability, mean, standard_dev)

The LOGNORM.INV function has the following arguments:

Argument	Description
probability	The probability associated with the lognormal distribution, a numeric value greater than 0 but less than 1.
mean	The mean of ln(x), a numeric value.
standard_dev	The standard deviation of ln(x), a numeric value greater than 0.

Notes

How to apply the LOGNORM.INV function.

Examples

The figure below displays the result returned by the LOGNORM.INV function.