# Documentation/Calc Functions/GAMMA

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

GAMMA

## Category:

Statistical Analysis

## Summary:

Calculates the value of the gamma function for a specified real number. In mathematics, the gamma function is an extension to the factorial function, which is only defined for the non-negative integers.

## Syntax:

GAMMA(**Number**)

## Returns:

Returns a real number which is the gamma function on **Number**.

## Arguments:

**Number** is a real number or a reference to the cell containing that number for which the gamma function value is to be calculated.

- If
**Number**is a negative integer or 0, then the function returns an error value.

## Additional details:

- The formula for GAMMA function is:

where x is the **Number**.

- GAMMA(x) can also be expressed as:

- For more details on gamma function, visit Wikipedia.

## Examples:

Formula | Description | Returns |
---|---|---|

=GAMMA(10) | The function calculates the gamma function value of 10 | 362880 |

=GAMMA(2.8) | The function calculates the gamma function value of 2.8 | 1.67649078776444 |

=GAMMA(-2.8) | The function calculates the gamma function value of -2.8 | -1.13860211111081 |

=GAMMA(-9) | The function returns error for negative integer values of Number. |
Err:502 |

=GAMMA(0) | The function returns an error for 0 value of Number. |
Err:502 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

GAMMA