Excel FACT Function

Summary
The Excel FACT function returns the factorial of a given number. For example, =FACT(3) returns 6, equivalent to 3 x 2 x 1.
Purpose
Find the factorial of a number
Return value
The factorial of a number
Syntax
=FACT (number)
Arguments
- number - The number to get the factorial of.
Version
Usage notes
The Excel FACT function returns the factorial of a given number. In mathematics, the factorial of a non-negative integer n is the product of all positive integers less than or equal to n, represented with the syntax n!
FACT takes just one argument, number, which should be a positive integer. If number is not an integer, the decimal portion of number will be removed before the factorial is calculated.
Examples
If number is not an integer it will be truncated to an integer:
=FACT(3.2) // returns 6
When number is zero, FACT returns 1:
=FACT(0) // returns 1
If number is negative, FACT returns the #NUM! error:
=FACT(-3) // returns #NUM!
Notes
- Number cannot be negative or FACT will return the #NUM error.
- If number is not an integer it will be truncated to an integer, then solved.
Download 100+ Important Excel Functions
Get over 100 Excel Functions you should know in one handy PDF.