LOGNORM.INV Function in Excel: Value for a Lognormal Probability

LOGNORM.INV Function in Excel: Value for a Lognormal Probability 1
⏱ 1 min readUpdated 5 October 2026

StatisticsLevel: ExpertAvailable in: Excel 2010+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. LOGNORM.INV in practice
  5. Where you will use it
  6. Worked example
  7. Mistakes people make
  8. Related functions

LOGNORM.INV returns the value at a lognormal probability.

Advertisement

Syntax

=LOGNORM.INV(probability, mean, standard_dev)
Argument What it means
probability 0..1
mean, standard_dev Of ln(x)

Examples

Example 1

=ROUND(LOGNORM.INV(A2,B2,C2),2)

Result: 90.02. See the worked example table below for more cases.

LOGNORM.INV in practice

Where you will use it

  • Price at the 5th percentile
  • Simulation
  • Risk limits

Worked example

pmean of lnsd of lnFormulaResult
0.54.50.3=ROUND(LOGNORM.INV(A2,B2,C2),2)90.02
0.054.50.3=ROUND(LOGNORM.INV(A3,B3,C3),2)54.96
0.9540.5=ROUND(LOGNORM.INV(A4,B4,C4),2)124.27

Results calculated in Excel.

Mistakes people make

MistakeWhat to do instead
p of 0 or 1#NUM!
Plain meanUse the log mean

LOGNORM.DIST

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZISOMITTED Function in Excel: Was an Optional Argument Left Out?Excel Functions A–ZYEAR Function in Excel: Year From a DateExcel Functions A–ZBETAINV Function in Excel: Inverse Beta (Older Name)
Advertisement
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong