The Excel FACT Function

Related Function:
FACTDOUBLE

Factorial

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

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

More information can be found on the Wikipedia Factorial page


Basic Description

The Excel FACT function returns the factorial of a supplied number

The format 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 being used to calculate the factorial of different integers. The format of the functions is shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

 Formulas:
Examples of use of the Excel Fact Function
 Results:
Excel Fact Function Results

Further examples of the Excel Fact function can be found on the Microsoft Office website.


Excel Fact Function Common 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 argument is < 0
#VALUE! - Occurs if the supplied number argument is not recognised as a numeric value
Return to the Excel Math Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2014 ExcelFunctions.net