Wauvel

Excel like a finance pro.

← The library

Compatibility function

GAMMAINV

Returns the inverse of the gamma cumulative distribution; replaced by GAMMA.INV.

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

When to use it

The inverse gamma cumulative distribution. Replaced by GAMMA.INV.

The shape of it

Syntax
=GAMMAINV(probability, alpha, beta)

Worked examples

  • Round trip

    =GAMMAINV(0.068094,9,2) → 10.0000112

    Reverses the GAMMADIST example.

  • Median

    =GAMMAINV(0.5,1,1) → 0.693147181

    Median of an exponential with mean 1.

  • Round trip

    =GAMMAINV(0.864664717,1,1) → 2

    Another round trip.

Worth knowing

  • GAMMA.INV is identical.
  • Iterative.
  • Random gamma: GAMMAINV(RAND(),alpha,beta).

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.