Compatibility - LOGINV Function

The LOGINV function replaces the LOGNORM.INV function in Excel 2010.

Description

The function 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 = LOGNORMDIST(x,...), then LOGINV(p,...) = x

Use the lognormal distribution to analyze logarithmically transformed data.

Syntax

LOGINV (probability, mean, standard_dev)

Arguments

Argument	Description	Required/ Optional
Probability	A probability associated with the lognormal distribution.	Required
Mean	The mean of ln(x).	Required
Standard_dev	The standard deviation of ln(x).	Required

Notes

The inverse of the lognormal distribution function is −

$$LOGINV(p,\mu,\sigma )=e^{[\mu + \sigma x(NORMSINV(p))]}$$
If any argument is nonnumeric, LOGINV returns the #VALUE! error value.
If probability <= 0 or probability >= 1, LOGINV returns the #NUM! error value.
If standard_dev <= 0, LOGINV returns the #NUM! error value.

Example

advanced_excel_compatibility_functions.htm