# Documentation/Calc Functions/FACT

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

## Function name:

FACT

## Category:

Mathematical

## Summary:

Calculates the factorial of a non-negative integer (denoted by *n*!).

## Syntax:

FACT(**Number**)

## Returns:

Returns a positive integer that is the factorial of the given argument.

## Arguments:

**Number** is a non-negative integer, or a reference to the cell containing that number, that is the value for which the factorial is to be calculated.

- If
**Number**is non-numeric, then FACT reports a #VALUE! error. - If
**Number**is a non-integer value, then FACT converts it to an integer by taking its floor value. - If
**Number**is less than 0, then FACT reports an invalid argument error (Err:502). - If
**Number**is greater than 170, then FACT reports a #VALUE! error. (170! is a very large number, approximately 7.26 E+306)

## Additional details:

- The formula for the factorial of a positive integer
*n*is:

[math]\displaystyle{ \text{FACT}(n)~=~n\times(n-1)\times(n-2)\times...\times\:1 }[/math]

- FACT(0) and FACT(1) are both equal to 1.
- For more information, visit Wikipedia’s Factorial page.

## Examples:

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

=FACT(3.5) | The floor value of 3.5 is 3 and 3! is equal to 3*2*1. | 6 |

=FACT(D1) where cell D1 contains the number 1. | 1! is equal to 1. | 1 |

=FACT(0) | 0! is defined to be 1. | 1 |

## Related LibreOffice functions:

## ODF standard:

## Related (or similar) Excel functions:

FACT