Extends factorial calculations to decimal numbers
=GAMMA(number)| Parameter | Description |
|---|---|
number |
A decimal number for which you want to calculate the gamma function value. |
The GAMMA function takes a single argument in this syntax:
=GAMMA(number)The argument number is the value for which you want to calculate the gamma function. Here are some basic examples showing both integer and non-integer
=GAMMA(0.5) // returns 1.7724538509... (√π)
=GAMMA(2) // returns 1
=GAMMA(2.5) // returns 1.3293403881...
=GAMMA(5) // returns 24The example below demonstrates the relationship between the GAMMA function and factorials. For any positive integer n, GAMMA(n) equals (n-1)!.
=GAMMA(n) // returns (n-1)!The GAMMA function returns #NUM! for zero and negative integers, and #VALUE! for non-numeric inputs.
=GAMMA(0) // returns #NUM! error
=GAMMA(-1) // returns #NUM! error
=GAMMA(-2) // returns #NUM! error
=GAMMA("text") // returns #VALUE! error