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

ArgumentRequired?What it does
probabilityYesThe share below the value, between 0 and 1 (not including 0 or 1).
meanYesThe mean of ln(x).
standard_devYesThe 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)
AB
1MeasureValue
2ln mean4
3ln std dev0.5
4Median order54.60
590th percentile103.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

Kyle Stott

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.