PERMUTATIONA
Formulas / PERMUTATIONACalculate the number of permutations with repetitions.
=PERMUTATIONA(number,number_chosen)
- number - an integer that describes the number of objects in a dataset
- number_chosen - an integer that describes the number of objects in each permutation
Examples
=PERMUTATIONA(3,2)Using the function in Sourcetable, you can calculate the number of permutations for a group with 3 objects that have 2 objects selected from the total objects. This function returns the number of permutations for a group with 3 objects, where 2 objects are selected from the total objects.
=PERMUTATIONA(2,2)Using the function in Sourcetable, you can calculate the number of permutations for a group with 2 objects. This function returns the number of permutations for a group with 2 objects, where all of the objects are selected from the total.
Summary
The PERMUTATIONA function is used to calculate the number of permutations for a given set of objects. It requires two arguments, the total number of objects and the number of objects in each combination.
- The PERMUTATIONA function returns the number of permutations of a given number of items, including repetitions of a value.
- To calculate the number of permutations without repetitions, use PERMUT.
- A permutation is a combination where order matters and there are two types of permutations: permutations where repetition is not allowed and permutations where repetition is allowed.
Need help with Formulas?
Frequently Asked Questions
What is the PERMUTATIONA function?
How many arguments does the PERMUTATIONA function take?
Are the arguments required?
What are the arguments?
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.