[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

FACT

Syntax:

FACT ( x )

Description: Computes the factorial of x.

Arguments:

Name

Type

Description

x

number

The non-negative value whose factorial is to be computed. x is truncated to an integer.

 

Return Type and Value: number – The factorial of x.

However, if

x is negative, #NUM! is returned.

x is too large for the result to be representable, #NUM! is returned.

[Example:

FACT(5) results in 120
FACT(3.5) results in 6
FACT(0) results in 1

end example]