Formulas > =PERMUT()

How To Use PERMUT() Function in Google Sheets


Returns the number of ways to choose some number of objects from a pool of a given size of objects, considering order.

Common questions about the PERMUT formula:
1. What is the PERMUT formula?
2. What does the PERMUT formula do?
3. How can the PERMUT formula be used?

How to use the PERMUT formula appropriately:
The PERMUT formula can be used to calculate the number of different permutations or combinations of a given set of items. It is a powerful tool for exploring the total possible arrangement of a given set of items.

How to mis-type the PERMUT formula:
It is possible to mis-type the formula as “PRMT” rather than “PERMUT”.

Common ways the PERMUT formula is used inappropriately:
Some people might use the PERMUT formula to calculate probabilities instead of combinations or permutations.

Common pitfalls when using the PERMUT formula:
The formula can cause an error when the range of numbers used as arguments is too large.

Common mistakes when using the PERMUT formula: 
The formula is often mis-typed as “PRMT” or “PREMUT”.

Common misconceptions people might have with the PERMUT Formula:
Some people may confuse the PERMUT formula with the COMBIN formula, which calculates the number of combinations from a given set of data.

How To Actually Use PERMUT() in Sheets

PERMUT(n, k)

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 PERMUT() formula:

Google Sheets - Finding a Permutation

Google Sheets - Finding a Permutation

Generate a PERMUT() 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.


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.