Advanced Excel Statistical - GAMMA Function

Description

The GAMMA function returns the gamma function value.

Syntax

GAMMA (number)

Arguments

Notes

• GAMMA uses the following equation −

  $$\Gamma \left ( N \right )=\int_{0}^{\infty}t^{N-1}e^{-t}dt$$

  $$\Gamma \left ( N+1 \right )=N^\ast \Gamma \left ( N \right )$$

• If Number is a negative integer or 0, GAMMA returns the #NUM! error value.

• If Number contains characters that are not valid, GAMMA returns the #VALUE! error value.

Applicability

Excel 2013, Excel 2016

Example