What does the PERMUT Google Sheets formula do?

The <code>PERMUT</code> function returns the number of permutations of a set of objects. A permutation is a way of arranging objects in a specific order. The function takes two arguments: <code>n</code>, the total number of objects, and <code>k</code>, the number of objects to arrange. The result is the number of possible permutations. This function is commonly used in combinatorics and probability theory.

How to use PERMUT Google Sheets formula?

The syntax for the PERMUT formula is =PERMUT(n, k), it has 2 required parameters.

PERMUT

The PERMUT function returns the number of permutations of a set of objects. A permutation is a way of arranging objects in a specific order. The function takes two arguments: n, the total number of objects, and k, the number of objects to arrange. The result is the number of possible permutations. This function is commonly used in combinatorics and probability theory.

How to use PERMUT formula?
Examples of using PERMUT formula
PERMUT formula not working?
Similar formulas to PERMUT

Usage

Use the PERMUT formula with the syntax shown below, it has 2 required parameters:

=PERMUT(n, k)

Parameters:

n (required):
The total number of objects in the set.
k (required):
The number of objects to arrange.

Examples

Here are a few example use cases that explain how to use the PERMUT formula in Google Sheets.

Calculate the number of ways to select a committee

Suppose you have 10 candidates to choose from to form a committee of 4 people. You can use the PERMUT function to calculate the number of ways to select the committee in different orders.

Calculate the number of ways to arrange letters in a word

You can use the PERMUT function to calculate the number of ways to arrange the letters in a word. For example, there are 6 permutations of the letters in the word 'ABC'.

Calculate the number of ways to deal cards

In a game of poker, there are 52 cards in a deck. You can use the PERMUT function to calculate the number of ways to deal 5 cards to each player in different orders.

Common Mistakes

PERMUT not working? Here are some common mistakes people make when using the PERMUT Google Sheets Formula:

Using the wrong order of n and k

Make sure to use the correct order of n and k. The correct syntax is PERMUT(n, k).

Using a non-integer value for n or k

The values for n and k must be integers. If a non-integer value is used, the function will return an error.

The following functions are similar to PERMUT or are often used with it in a formula:

COMBIN
The COMBIN function calculates the number of combinations for a given number of items. A combination is a way of selecting items from a larger set where order does not matter. This function is commonly used in probability and statistics.
FACT
The FACT formula calculates the factorial of a given number. The factorial of a number is the product of all positive integers from 1 to the given number. This formula is commonly used in probability and combinatorics.
BINOMDIST
The BINOMDIST function calculates the probability of a certain number of successes in a fixed number of trials given a constant probability of success for each trial. This function is commonly used in statistical analysis and hypothesis testing.

Learn More

You can learn more about the PERMUT Google Sheets function on Google Support.