FACT

Archived content. No warranty is made as to technical accuracy. Content may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

Returns the factorial of a number. The factorial of a number is equal to 1*2*3*...* number.

Syntax

FACT ( number )

Number is the nonnegative number you want the factorial of. If number is not an integer, it is truncated.

Example

Formula

Description (Result)

=FACT(5)

Factorial of 5, or 1*2*3*4*5 (120)

=FACT(1.9)

Factorial of the integer of 1.9 (1)

=FACT(0)

Factorial of 0 (1)

=FACT(-1)

Negative numbers cause an error value (#NUM!)

=FACT(1)

Factorial of 1 (1)