Spread Formula Reference
FACT
Formula Functions > Functions D to G > FACT

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