FACT

This function calculates the factorial of the specified number.

Syntax

FACT(number)

Arguments

[Required] The nonnegative number for which you want the factorial. If number is not an integer, it is truncated.

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.

Examples

FACT(B3)

FACT(R1C2)

FACT(10) gives the result 3628800