SheetFX
≡
<< Go back to all functions

PERMUTATIONA

The PERMUTATIONA function in Google Sheets returns the number of permutations for selecting a group of objects (with replacement) from a total number of objects.

Function Syntax and Parameters

Syntax: PERMUTATIONA(number, number_chosen)

Parameters:

  • number: The total number of objects to choose from.
  • number_chosen: The number of objects to choose.

Step-by-Step Tutorial

  1. Using PERMUTATIONA to calculate permutations:
    • Example: =PERMUTATIONA(5, 3)
    • Result: 60

Use Cases and Scenarios

  1. Probability Calculation: Find the number of ways to arrange a group from a larger set.
  2. Combinatorics: Determine the number of possible arrangements in a game or puzzle.
  3. Sampling: Calculate the number of possible combinations when selecting objects.

Related Functions

  • None

Related Articles

  • None