Menu
PERMUT Function
Excel PERMUT Function Introduction
Provides the number of permutations for a given set of objects that may be chosen from a set of number objects. Any collection or subset of objects or events whose internal order is significant is referred to as a permutation. Permutations vary from combinations in that the internal order is unimportant. This function is useful for calculating lottery-style probability.
Description of Excel PERMUT Function
Syntax :
=PERMUT(number, number selected)
Parameters :
- There is a number required. An integer indicating the number of items.
- Number chosen Required. The number of items in each permutation is represented by an integer.
Step By Step Guide of PERMUT Function
Example :
To utilise PERMUT, enter the total number of items and “number chosen,” which specifies the number of elements in each combination. For example, to calculate 3-number permutations for the digits 0-9, there are 10 numbers and 3 chosen, hence the formula is:
Key Points
- Both parameters have been reduced to integers. PERMUT returns the #VALUE! error value if number or number chosen is nonnumeric.
- If number 0 or number chosen 0 is returned, PERMUT returns the #NUM! error value.
- PERMUT returns the #NUM! error value if number number chosen.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
