Skip to content
Excel

FACT function in Excel

Returns the factorial of a number

=FACT(number)

FACT syntax and parameters

One argument, one required.

  • numbernumberRequired

    The nonnegative number for which you want the factorial. If number is not an integer, it is truncated.

FACT examples

Formulas you'll actually reuse.

  1. Ways to order B2 items — 5! is 120:

    =FACT(B2)

    Result120

  2. Combinations by hand (COMBIN does this directly):

    =FACT(10) / (FACT(3) * FACT(7))

    Result120

FACT in Google Sheets

Same name — your formula ports as-is.

Try FACT in the playground

Edit the example — nothing to install.

Preloaded with the FACT formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.