Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

PERMUTATIONA

Returns the number of permutations (including repetitions) of a number of objects from a given set of objects. 


Sample Usage

PERMUTATIONA(4,3)
PERMUTATIONA(A2,A3)

Syntax

PERMUTATIONA(number1, number2)

  • number1 - The total number of objects.
  • number2 - The number of objects to choose.


Examples

PERMUTATIONA(4,3) returns a value of 64.
PERMUTATIONA(A2,A3) returns all the permutations possible for the arguments specified in A2 and A3. 


Notes

  • Both arguments are truncated to integers.
  • If either number is zero, PERMUTATIONA returns an error.