# Its a FACT Jack

### Working out how many combinations are possible

Do you remember factorials in maths? That’s where you have, say four numbers, and you want to find out how many four number combinations you can make with those four numbers. In Maths you write it as 4!. The answer is 4 x 3 x 2 x 1 = 24.

This type of calculation can be useful when you are working out probabilities and need to calculate how many possible combinations or permutations are possible.

Excel has a FACT function that simplifies the calculation. The above calculation is written as

`=FACT(4)`

You can use cell references

`=FACT(A1)`

You can’t use negative numbers and if you use zero, it will return 1.

``` Related Posts Identifying if a List has Unique Entries in Excel Adding up Text Numbers In Excel Another Technique The Magical N Function in Excel Financial Year Month in a Pivot Table Find the Closest Value in Excel ```

Please note: I reserve the right to delete comments that are offensive or off-topic.

This site uses Akismet to reduce spam. Learn how your comment data is processed.