Wauvel

Excel like a finance pro.

← The library

Statistical function

GAMMA.INV

Returns the inverse of the gamma cumulative distribution.

Rarely usedDifficulty 1550 · AdvancedUsage rank #445 of 520
Practice · 2 questions →

When to use it

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

The shape of it

Syntax
=GAMMA.INV(probability, alpha, beta)

Worked examples

  • Round trip

    =GAMMA.INV(0.59399415,2,1) → 2

    Inverts the GAMMA.DIST example.

  • Exponential median

    =GAMMA.INV(0.5,1,1) → 0.693147181

    The median of an exponential with mean 1 is LN(2).

  • Round trip

    =GAMMA.INV(0.864664717,1,1) → 2

    Another round trip.

Worth knowing

  • Random gamma values: GAMMA.INV(RAND(),alpha,beta).
  • Percentiles of claim severity for reserving.
  • Replaces GAMMAINV.

Where it goes wrong

  • #NUM! for probability outside 0 to 1 or non-positive parameters.
  • Iterative, so extreme parameters can be slow.

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.