Buzz
This article introduces you to the PERMUTATIONA function - one of the statistical functions widely used in Excel.
Description: The function returns the count of permutations (with possible repetition) of a given set of objects. Supported from Excel 2013 onwards.
Syntax: PERMUTATIONA(number, number_chosen)
In which:
- number: An integer determining the number of objects, is a mandatory parameter.
- number_chosen: An integer determining the number of objects in 1 permutation, is a mandatory parameter.
Note:
- If number, number_chosen are not integers -> they are truncated to integers.
- If number, number_chosen are not numeric -> the function returns an error value #VALUE!
- If number ≤ 0 or number_chosen < 0 -> the function returns an error value #NUM!
Example:
Find the permutations of 4 elements from 12 elements described in the dataset below:
- Enter the formula: =PERMUTATIONA(E6,E7) into the cell to calculate.
- Press Enter -> the permutations of 4 elements is:
- Since elements in the permutation can repeat, if number (number of objects)< number_chosen (number of objects in one permutation)-> the function still computes and returns the correct value:
- If number ≤ 0 or number_chosen < 0 -> the function returns an error value #NUM!
Here is the guide and some specific examples when using the PERMUTATIONA function in Excel.
Wishing you success!
