How to Use the GAMMA Function in Excel

This guide explains how to use GAMMA Function in Excel, including its syntax, required arguments, practical examples, and common errors.

Description: The function returns the gamma function value . Support functions from Excel 2013 onwards.

Syntax: GAMMA (number )

Inside:

- number: The value you want to calculate the gamma function value .

Attention:

- Function of calculation using equation:

[Gamma left (N right) = intlimits_0 ^ infty {{t ^ {N - 1}} {e ^ {- t}} dt}]

- If number is a negative integer or equal to 0 -> the function returns the #NUM! Error value .

- If the number value is not valid -> the function returns the error value #VALUE!

For example:

Find the value of the GAMMA function of the values in the data table below:

u

- In the cell to calculate enter the formula : = GAMMA (C6)

- Similarly copying the formula for the remaining values results:

- Where the number value is a negative integer or equal to 0 -> the function returns the #NUM! Error value

- Where the number value is not a numerical value -> the function returns the error value #VALUE!

Above are instructions and some specific examples when using the GAMMA function in Excel.

Good luck!