Formulas > =PERMUTATIONA()

How To Use PERMUTATIONA() Function in Google Sheets


Returns the number of permutations for selecting a group of objects (with replacement) from a total number of objects.

Common questions about the PERMUTATIONA formula:

1. What is the syntax of the formula?
2. How do you determine the number of permutations?
3. How do you use the PERMUTATIONA formula to calculate different permutations?

How can the PERMUTATIONA formula be used appropriately?

The formula can be used to calculate the number of possible permutations of a given set of objects. This is usually done by taking the factorial of the number of elements.

How can the PERMUTATIONA formula be commonly mistyped?

The formula is commonly mistyped as “Permutations”, “Permutations Formula”, or “PERMUTATION Formula”.

What are some common ways the PERMUTATIONA formula is used inappropriately?

The formula is often used to calculate combinatorial problems that do not involve permutations. This may lead to incorrect results.

What are some common pitfalls when using the PERMUTATIONA formula?

When calculating permutations, order matters. Therefore when using the formula, it is important to pay attention to the order of the objects being permuted.

What are common mistakes when using the PERMUTATIONA Formula?

A common mistake is forgetting to calculate the factorial of the number of elements. This will result in incorrect results. Additionally, confusion can arise when including repeated elements, as the formula does not account for duplicate values.

What are common misconceptions people might have with the PERMUTATIONA Formula?

One misconception is that the PERMUTATIONA formula will automatically account for duplicate values. This is not the case and must be accounted for in the calculation. Additionally, people may think that the formula can be used to calculate combinations, when in fact it is only used to calculate permutations.

How To Actually Use PERMUTATIONA() in Sheets

PERMUTATIONA(number, number_chosen)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the PERMUTATIONA() formula:

Permutationa function example in excel

This video shows you how to get number of permutations with repetitions using permutationa formula in MS Excel 2019 Office 365.

Generate a PERMUTATIONA() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.