LOGNORM.INV

LOGNORM.INV(probability, mean, standard_dev)

Returns the inverse of the probability distribution function for a lognormal distribution.

probability	The probability associated with the distribution.
mean	The arithmetic mean of the distribution.
standard_dev	The standard deviation of the distribution.

REMARKS

* For an illustrated example refer to the page under Distributions
* The lognormal distribution is a continuous distribution
* ln(x) is normally distributed with parameters mean and standard_dev
* This function was added in Excel 2010 to replace the LOGINV function.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=LOGNORM.INV(0.029084, 3.5, 1.2) = 3.410
2	=LOGNORM.INV(0.5, 2, 1) = 7.389