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).
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.