Wauvel

Excel like a finance pro.

← The library

Statistical function

LOGNORM.INV

Returns the inverse of the lognormal cumulative distribution.

Rarely usedDifficulty 1500 · AdvancedUsage rank #402 of 520
Practice · 2 questions →

When to use it

The value at a given cumulative probability of the lognormal distribution.

The shape of it

Syntax
=LOGNORM.INV(probability, mean, standard_dev)

Worked examples

  • Round trip

    =LOGNORM.INV(0.039084,3.5,1.2) → 4.0000252

    Inverts the LOGNORM.DIST example.

  • Median

    =LOGNORM.INV(0.5,0,1) → 1

    The median is EXP(mean).

  • Upper percentile

    =LOGNORM.INV(0.975,0,1) → 7.099327

    EXP(1.96): the 97.5th percentile.

Worth knowing

  • Same as EXP(NORM.INV(p,mean,sd)).
  • Random lognormal: LOGNORM.INV(RAND(),mean,sd).
  • Replaces LOGINV.

Where it goes wrong

  • #NUM! for probability outside 0 to 1.
  • Parameters are for LN(x).

Related

AVERAGECOUNTCOUNTACOUNTIFCOUNTIFSMAX

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.