Spread WPF Documentation
FACT
Spread WPF Documentation > Formula Reference > Formula Functions > FACT

Summary

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

See Also