logo
excelfunctions.org
bookmarks

PERMUTATIONA

Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects.

StatisticalStatistics & Analysis

What it does

Calculates permutations with repetition allowed.

Syntax

PERMUTATIONA(number, number_chosen)

Arguments

  • number(number) β€” Total objects.
  • number_chosen(number) β€” Number selected.

Examples

Permutations w/ Reps

Pick 2 from 3 with replacement.

FORMULA
=PERMUTATIONA(3, 2)
RESULT
9
SAMPLE DATA
AB
1nk
232