What is permutation function with reputation in Excel?

Answer 1

The PERMUT function in Excel gives you permuations of a set of numbers. That is the different combinations in different orders. If you take the numbers 1, 2 and 3, the following are all their permutations:

1,2,3

1,3,2

2,1,3

2,3,1

3,1,2

3,2,1

So there are 6 permutations. That would be the permutations of 3 numbers from a set of 3 numbers. You can also get permutations of a small amount of numbers from a larger set of numbers, like the way a lottery works. So if you have to choose 3 numbers out of 6 numbers, there are 120 permutations. In Excel you would type the function like this:

=PERMUT(6,3)