This function calculates the factorial of the specified number.
Syntax
FACT(number)
Arguments
The argument can be any numeric value.
Remarks
The factorial is the product of the positive integers less than or equal to a number and is calculated as 1 x 2 x 3 x . . . x number, and is typically written as n! for n being the number. For example, 4! is 1 x 2 x 3 x 4, which is 24. The argument must be a non-negative number. If you provide a number that is not an integer for the argument, the decimal portion of the number is ignored.
Data Types
Accepts numeric data. Returns numeric data.
Examples
FACT(B3)
FACT(R1C2)
FACT(10) gives the result 3628800
Version Available
This function is available in product version 1.0 or later.
See Also
FACTDOUBLE | PRODUCT | Math and Trigonometry Functions