The Excel FACT Function
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 DescriptionThe 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. ExamplesCells 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.
Further examples of the Excel Fact function can be found on the Microsoft Office website. Trouble ShootingIf you get an error from the Excel Fact function this is likely to be one of the following : Common Errors
|
|||||||||||
|
|
|||||||||||
|
|
Copyright © 2008-2011 ExcelFunctions.net |
