Author: Oscar Cronquist Article last updated on May 04, 2022

The FACT function returns the factorial of a number.

Formula in cell C3:


Example, 3! = 3*2*1 = 6

1. FACT Function Syntax


Back to top

2. FACT Function Arguments

number Required. The number equal to or larger than 0 (zero) for which you want to calculate the factorial.

If number is not an integer, it is truncated.

Returns an error if the number argument is a text value.

Back to top

3. FACT Function example

The FACT function is useful if you want to calculate the number of permutations of a given set of elements.

The following set has three elements: [A, B, C].

3! = 3*2*1 = 6. You can rearrange [A, B, C] in six different permutations.

1, [A, B, C]
2, [A, C, B]
3, [B, A, C]
4, [B, C, A]
5, [C, A, B]
6, [C, B, A]

Back to top