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

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

  1. Gamma of 5 is 4 factorial

    ABC
    1x
    2524

    In C2: =GAMMA(A2) → 24

    Try this example

  2. Between whole numbers

    ABC
    1x
    22.51.3293

    In C2: =GAMMA(A2) → 1.3293

    Try this example

Common mistakes

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.

Translate a whole formula

Try GAMMA in the playground

Related functions