# 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:
A B
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:
A B
1 6 = 3 x 2 x 1
2 720 = 6 x 5 x 4 x 3 x 2 x 1
3 3628800 = 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.