The Excel FACT Function

Related Function:
FACTDOUBLE
Factorial

The Factorial of a number, N, is given by the product:

N * (N-1) * ... * 2 * 1

For further details, see the Wikipedia Factorial page

Basic Description

The Excel Fact function returns the factorial of a supplied number.

The syntax of the function is:

FACT( number )

where the number argument is the positive integer that you want to calculate the factorial of.


Excel Fact Function Examples

Cells A1-A3 of the following spreadsheet shows examples of the Excel Fact function, used to calculate the factorial of the integers 3, 6 and 10.

 Formulas:
 AB
1=FACT( 3 )= 3 x 2 x 1
2=FACT( 6 )= 6 x 5 x 4 x 3 x 2 x 1
3=FACT( 10 )= 10 x 9 x 8 x 7 x 6 x 5 x 4 x 3 x 2 x 1
 Results:
 AB
16= 3 x 2 x 1
2720= 6 x 5 x 4 x 3 x 2 x 1
33628800= 10 x 9 x 8 x 7 x 6 x 5 x 4 x 3 x 2 x 1

Further examples of the Excel Fact function are provided on the Microsoft Office website.


Excel Fact Function Errors

If you get an error from the Excel Fact function this is likely to be one of the following:

Common Errors
#NUM!-Occurs if the supplied number is < 0.
#VALUE!-Occurs if the supplied number is non-numeric.