PERMUT

Formulas / PERMUT
Calculate the number of permutations without repetitions.
=PERMUT(number,number_chosen)
  • number - an integer, required
  • number_chosen - an integer, required

Examples

  • =PERMUT(2,4,6)

    The PERMUT function can be used to calculate the number of permutations for a given set of numbers. For example, if you wanted to calculate the number of permutations for the numbers 2, 4, and 6, you would use the formula. This formula would return the number of permutations for the given set of numbers, which in this case would be 12.

  • = PERMUT(A2:A6)

    The PERMUT function can also be used to calculate the number of permutations for a range of numbers. For example, if you wanted to calculate the number of permutations for the numbers from 3 to 6, you would use the preceding formula. This formula would return the number of permutations for the range of numbers, which in this case would be 120.

  • =PERMUT(2,4,6,2)

    The PERMUT function can also be used to calculate the number of permutations for a given set of numbers with a given repetition. For example, if you wanted to calculate the number of permutations for the numbers 2, 4, and 6 with repetition, you would use the above formula. This formula would return the number of permutations for the given set of numbers with a repetition of 2, which in this case would be 36.

Summary

The PERMUT function is used to calculate the number of permutations for a given set of objects or events. It is often used for lottery-style probability calculations.

  • The PERMUT function calculates permutations where repetitions are not allowed.
  • The PERMUTATIONA and COMBIN functions allow repetitions and calculate permutations where repetitions are allowed.
  • The COMBINA function calculates permutations where repetitions are allowed.


Frequently Asked Questions

What is the PERMUT function?
The PERMUT function is a calculation that determines the number of permutations for a given number of objects. A permutation is a set or subset of objects or events.
What is the purpose of the PERMUT function?
The PERMUT function is used to calculate probability when dealing with lottery-style games.
How is the PERMUT function used?
The PERMUT function can be used to calculate the number of different outcomes in a lottery-style game. For example, if you have a lottery game with five numbers, the PERMUT function can be used to calculate the total number of possible outcomes.
What are some examples of how the PERMUT function can be used?
  • Calculating the total number of possible outcomes in a lottery-style game.
  • Determining the probability of certain outcomes in a lottery-style game.
  • Calculating the number of different arrangements of a given set of objects.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV