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


You can use cell references


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

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

Leave a Reply

Your email address will not be published. Required fields are marked *

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