PERMUTATIONA function

The 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

PERMUTATIONA(number, number_chosen)

Part Description
number Required. The total number of objects to choose from.
number_chosen Required. The number of objects to choose from number. Must be less than or equal to number.

Notes

  • Both arguments are truncated to integers.
  • If the number is zero, PERMUTATIONA returns a #NUM.

Examples

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.

  A B
1 PERMUTATIONA Formula
2 99 =PERMUTATIONA(3, 2)
3 9  
4 9 =PERMUTATIONA(3.2, 2.3)

Related functions

  • 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).
Was this helpful?
How can we improve it?