FACT Function in Excel: Factorial

⏱ 1 min readUpdated 28 September 2026

MathLevel: IntermediateAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. Common errors and fixes
  5. Related functions

FACT returns n! (1 × 2 × … × n). It grows absurdly fast: FACT(20) is already about 2.4 quintillion.

Syntax

=FACT(number)
Argument What it means
number Non-negative; decimals are truncated.

Examples

Example 1

=FACT(5)

120 ways to order five books on a shelf.

Common errors and fixes

You see Why, and the fix
#NUM! Negative input, or above 170 (the result overflows Excel’s number limit).

COMBIN · PERMUT

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZBIN2DEC Function in Excel: Binary to DecimalExcel Functions A–ZEXP Function in Excel: e Raised to a PowerExcel Functions A–ZBYROW Function in Excel: Apply a Calculation to Each Row
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong