Quick Navigation
LOGINV Function
Summary
The LOGINV function calculates the inverse of the lognormal cumulative distribution, returning the value x where ln(x) follows a normal distribution with specified mean and standard deviation. Essential for statistical analysis of logarithmically transformed datasets.
Syntax
LOGINV(probability, mean, standard_dev)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| probability | Number |
Yes | Probability value associated with the lognormal distribution (0 < probability < 1) |
| mean | Number |
Yes | Mean value of the natural logarithm ln(x) |
| standard_dev | Number |
Yes | Standard deviation of the natural logarithm ln(x) |
Using the LOGINV Function
LOGINV is valuable in statistical modeling for financial analysis, risk assessment, and natural processes analysis where data follows a lognormal distribution. Use it to find specific percentile values or threshold points in log-transformed datasets.
Common LOGINV Examples
Basic LOGINV Calculation
=LOGINV(0.039084, 3.5, 1.2)Returns approximately 4.0000252, the inverse lognormal value for the given probability, mean, and standard deviation.
Financial Percentile Analysis
=LOGINV(0.95, A1, B1)Calculates the 95th percentile value for a lognormally distributed financial metric.
Frequently Asked Questions
Common Errors and Solutions
#VALUE! error
Cause: Any argument is non-numeric
Solution: Ensure all inputs are valid numbers
#NUM! error
Cause: Probability ≤ 0 or ≥ 1, or standard_dev ≤ 0
Solution: Verify probability is between 0 and 1 (exclusive), and standard_dev is positive
#NUM! error
Cause: Standard deviation is zero or negative
Solution: Provide a positive standard deviation value
Notes
- Deprecated function - consider using LOGNORM.INV for better accuracy
- Ideal for modeling stock prices, real estate values, and biological measurements
- Excel 2007+ compatibility with backward compatibility warning
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in: Excel 2003 and earlier
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+