# 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

## Function 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.