Author: Oscar Cronquist Article last updated on May 11, 2022

The GAMMA.DIST function calculates the gamma often used in queuing analysis (probability statistics) that may have a skewed distribution.

This function was introduced in Excel 2010 and has replaced the GAMMADIST function.

Formula in cell C7:


Excel Function Syntax



x Required.
alpha Required.
beta Required. 1 returns the standard gamma distribution.
cumulative Required. A boolean value.
TRUE - cumulative distribution function
FALSE - probability density function


The GAMMA.DIST function returns

  • #VALUE! error value if alpha, beta or x is non-numeric.
  • #NUM! error value if:
    • x < 0 (zero)
    • alpha <= 0 (zero)
    • beta <= 0 (zero)

The equation to calculate the gamma probabiltiy density function:

The standard gamma probability function: