LOGNORM.INV Function
Returns the value at a given probability of a lognormal distribution.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Want to practice LOGNORM.INV in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
LOGNORM.INV is the reverse of LOGNORM.DIST: give it a probability and it returns the value with that share below it. It equals EXP(NORM.INV(probability, mean, standard_dev)).
Syntax
=LOGNORM.INV(probability, mean, standard_dev) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| probability | Yes | The share below the value, between 0 and 1 (not including 0 or 1). |
| mean | Yes | The mean of ln(x). |
| standard_dev | Yes | The standard deviation of ln(x); must be greater than 0. |
Examples
Example 1 — Median and 90th-percentile order
Order values with ln-mean 4 and ln-standard-deviation 0.5.
B4fx=LOGNORM.INV(0.5,B2,B3)
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | ln mean | 4 |
| 3 | ln std dev | 0.5 |
| 4 | Median order | 54.60 |
| 5 | 90th percentile | 103.62 |
=LOGNORM.INV(0.5,B2,B3) Explain
Half of orders are under about $54.60, and 90% are under about $103.62.
Common mistakes
- #NUM! probability is 0 or less or 1 or more, or standard_dev is 0 or negative.
Notes
- Related functions: LOGNORM.DIST, NORM.INV, EXP.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.