Wauvel

Excel like a finance pro.

← The library

Compatibility function

LOGINV

Returns the inverse of the lognormal cumulative distribution; replaced by LOGNORM.INV.

Rarely usedDifficulty 1450 · AdvancedUsage rank #448 of 520
Practice · 2 questions →

When to use it

The inverse lognormal cumulative distribution. Replaced by LOGNORM.INV.

The shape of it

Syntax
=LOGINV(probability, mean, standard_dev)

Worked examples

  • Round trip

    =LOGINV(0.039084,3.5,1.2) → 4.0000252

    Reverses the LOGNORMDIST example.

  • Median

    =LOGINV(0.5,0,1) → 1

    Median is EXP(mean).

  • Upper percentile

    =LOGINV(0.975,0,1) → 7.099327

    Upper percentile.

Worth knowing

  • LOGNORM.INV is identical.
  • Parameters are for LN(x).
  • Same as EXP(NORMINV(p,mean,sd)).

Where it goes wrong

  • #NUM! for probability outside 0 to 1.
  • Flagged by the Compatibility Checker.

Related

FORECASTMODEPERCENTILEQUARTILERANKSTDEV

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.