Wauvel

Excel like a finance pro.

← The library

Compatibility function

GAMMADIST

Returns the gamma distribution; replaced by GAMMA.DIST.

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

When to use it

The gamma distribution. Replaced by GAMMA.DIST.

The shape of it

Syntax
=GAMMADIST(x, alpha, beta, cumulative)

Worked examples

  • Density

    =GAMMADIST(10.00001131,9,2,FALSE) → 0.032639

    Density.

  • Cumulative

    =GAMMADIST(10.00001131,9,2,TRUE) → 0.068094

    Cumulative.

  • Exponential case

    =GAMMADIST(2,1,1,TRUE) → 0.864664717

    Alpha 1 is exponential.

Worth knowing

  • GAMMA.DIST is identical.
  • Beta is a scale parameter.
  • GAMMAINV for percentiles.

Where it goes wrong

  • #NUM! for negative x or non-positive parameters.
  • 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.