## How to use the FACT function

*Article updated on January 30, 2018*

Returns the factorial of a number.

Formula in cell C3:

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

### Excel Function Syntax

FACT(*number*)

### Arguments

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

### Comments

If *number* is not an integer, it is truncated.

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

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]

### Articles with the 'FACT' Function

List permutations with repetition and how many to choose from

Noel asks: Is there a way where i can predict all possible outcomes in excel in the below example. Total […]