## FACT function

Excel ยป Functions ยป Math and trigonometry ยป FACT function ยป

How to use the FACT function

The FACT function returns the factorial of a number. Formula in cell C3: =FACT(B3) Example, 3! = 3*2*1 = 6 [โฆ]

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 [โฆ]

Permutations with and without repetition

I discussed the difference between permutations and combinations in my last post, today I want to talk about two kinds [โฆ]

Return all combinations

Today I have two functions I would like to demonstrate, they calculate all possible combinations from a cell range. What [โฆ]

Create permutations [UDF]

Chris asks: Maximum Number Allowed is 4 digit and the number is from 0 to 9. After I fill in [โฆ]

List permutations without repetition [UDF]

This blog post describes how to create permutations, repetition is NOT allowed. Permutations are items arranged in a given order meaning [โฆ]

List permutations with repetition [UDF]

This blog post demonstrates a custom function (UDF) that creates permutations. Repetition is allowed. The custom function lets you specify the [โฆ]