Author: Oscar Cronquist Article last updated on September 03, 2018

The GAMMA function calculates the GAMMA value. It is an extension of the factorial function, the argument is shifted down by 1.

Formula in cell C3:


Excel Function Syntax



number Required.


The GAMMA function returns

  • #NUM! error value if number is a negative integer or 0 (zero).
  • #VALUE! error value if number contains invalid characters

Formula equation