PERMUTATIONA

Formulas / PERMUTATIONA
Calculate 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.

Frequently Asked Questions

What is the PERMUTATIONA function?
The PERMUTATIONA function is a mathematical function used to calculate the number of permutations for a given number of objects.
How many arguments does the PERMUTATIONA function take?
The PERMUTATIONA function takes two arguments.
Are the arguments required?
Yes, the arguments are required.
What are the arguments?
The arguments are the number of objects and the number of objects in each permutation, respectively.
Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV