The `PERMUTATIONA` function in Excel is used to calculate the number of permutations (ordered arrangements) of a set where repetition of elements is allowed. In other words, it tells you how many ways you can arrange `n` items taken `k` at a time, allowing for repeated elements.
Syntax
PERMUTATIONA(number, number_chosen)
- `number`: The total number of items to choose from.
- `number_chosen`: The number of items to choose.
How to Use
- Open your Excel worksheet.
- Select a cell where you want the result to appear.
- Enter the formula using the `PERMUTATIONA` function.
Example
Suppose you want to find out how many ways you can arrange 3 items chosen from a set of 5, with repetition allowed.
- Formula: `=PERMUTATIONA(5, 3)`
Explanation
- The `number` is `5` because you are choosing from a set of 5 items.
- The `number_chosen` is `3` because you are arranging 3 items.
Result
In this case, the `PERMUTATIONA` function will return `125`, because:
- With repetition, each position has 5 possible choices (from the 5 items), so the total arrangements are (5 times 5 times 5 = 5^3 = 125).
Important Notes
- The `PERMUTATIONA` function is available in Excel 2013 and later versions.
- If either of the inputs are non-numeric, Excel will return a `#VALUE!` error.
- If `number` or `number_chosen` are negative, Excel will return a `#NUM!` error.
Unlock Your Potential
Excel
Access
Power BI
