ReferenceFunctionsMath Functions
FACT
Returns the factorial of a non-negative integer.
Summary
FACT truncates fractional inputs toward zero before computing the factorial.
Remarks
- Non-numeric values that cannot be coerced return
#VALUE!. - Negative inputs return
#NUM!. - Results above
170!overflow Excel-compatible limits and return#NUM!.
Examples
Basic factorial
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
120
Fractional input is truncated
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
120
Negative input returns numeric error
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
#NUM!
Related functions
FAQ
Why does FACT(171) return #NUM!?
Excel-compatible factorial support is capped at 170!; larger values overflow and return #NUM!.
Does FACT round fractional inputs?
No. It truncates toward zero before computing the factorial.
Runtime metadata
Category
Math
Signature
FACT(arg1: Number)Arity
min 1, max 1
Arguments
arg1Number · Scalar · coercion NumberLenientText
Caps
PURE
Source