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.