Navigation:  Formula Reference > Spreadsheet Formula Functions >

FACT

Previous pageReturn to chapter overviewNext page

 

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

FACTDOUBLE

PRODUCT