PERMUTATIONA functionThe PERMUTATIONA function returns the number of permutations for selecting a group of objects (with replacement) from a total number of objects. Mathematically, it is equivalent to raising the total number of objects to the number of objects being chosen.
Parts of a PERMUTATIONA function
Required. The total number of objects to choose from.
Required. The number of objects to choose from number. Must be less than or equal to number.
Both arguments are truncated to integers.
If the number is zero, PERMUTATIONA returns a #NUM.
Result for A1=PERMUTATIONA(3, 2), A2=PERMUTATIONA(3.2, 2), A3= PERMUTATIONA(3, 2.4).
Note: All functions return the same result due to truncation.
PERMUT: Returns the number of ways to choose some number of objects from a pool of a given size of objects, considering order.
COMBIN: The COMBIN function returns the number of ways to choose some number of objects from a pool of a given size of objects.
COMBINA: The COMBINA function returns the number of ways to choose some number of objects from a pool of a given size of objects, including ways to choose the same object multiple times (also known as choosing with replacement).