Excel functions / Math
GAMMA function
The gamma function, which stretches the factorial to numbers that are not whole: GAMMA(n) is (n-1)!
Syntax
=GAMMA(number)
Arguments
number: Any number except 0 and the negative whole numbers.
When to use it
GAMMA stretches the factorial to numbers that are not whole: GAMMA(n) is (n-1)! for whole numbers, and it has a value between them too.
Examples
Gamma of 5 is 4 factorial
A B C 1 x 2 5 24 In C2:
=GAMMA(A2)→ 24Between whole numbers
A B C 1 x 2 2.5 1.3293 In C2:
=GAMMA(A2)→ 1.3293
Common mistakes
- Zero and negative whole numbers. GAMMA has no value at 0, -1, -2…: #NUM!.
GAMMA in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: GAMMA
- Danish: GAMMA
- Dutch: GAMMA
- Finnish: GAMMA
- French: GAMMA
- German: GAMMA
- Hungarian: GAMMA
- Italian: GAMMA
- Norwegian: GAMMA
- Polish: GAMMA
- Portuguese (Brazil): GAMA
- Portuguese (Portugal): GAMA
- Russian: ГАММА
- Spanish: GAMMA
- Swedish: GAMMA
- Turkish: GAMA
Related functions
- GAMMALN: The natural logarithm of the gamma function. It stays small where GAMMA itself would overflow.
- FACT: Factorial: 1 × 2 × … × n.
- GAMMA.DIST: The gamma distribution, for values that cannot be negative and lean to the right, such as waiting times.