Spread 8.0 Documentation
FACT
Support Options
Formula Reference > Built-In Functions > FACT

Glossary Item Box

FACT


Name

Factorial

Description

Returns the factorial of the specified number.

Syntax

FACT(value)

Remarks

The value argument must be a nonnegative number. The factorial is calculated as 1×2×3× . . . ×value. If you provide a number that is not an integer for the value argument, the decimal portion of the number is ignored.

See also PRODUCT.

Data Type

Accepts numeric data. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

FACT(R1C2)
FACT(B3)
FACT(10)=3628800

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.