PERMUTATIONA Function Explained
The PERMUTATIONA
function in Microsoft Excel calculates the number of permutations for a given number of objects that can be selected from a larger set. It takes two arguments: number
and number_chosen
. number
is the total number of objects in the set, and number_chosen
is the number of objects to be selected from the set. The result is the number of possible combinations of the objects that can be selected from the set.
PERMUTATIONA Function Syntax
PERMUTATIONA(number, number_chosen)
- number: The total number of items from which the sample is chosen.
- number_chosen: The number of items in the sample.