PERMUTATIONA function - The function returns the number of permutations (can be repeated) of a given object in Excel
The following article introduces you to the PERMUTATIONA function - one of the functions in the group of statistical functions that is very popular in Exc Bl.
PERMUTATIONA function - The function returns the number of permutations (can be repeated) of a given object in Excel Picture 1
Description: The function returns the number of permutations (iterations) of a given object. Support functions from Excel 2013 onwards.
Syntax: PERMUTATIONA (number, number_chosen)
Inside:
- number: Integer specifies the number of objects, is the required parameter .
- number_chosen: An integer that specifies the number of objects in a permutation, which is a required parameter.
Attention:
- If number, number_chosen are not whole numbers -> they are truncated to whole numbers.
- If number, number_chosen are not numbers -> the function returns the #VALUE! Error value
- If number ≤ 0 or number_chosen <0 -> the function returns the #NUM! Error value
For example:
Find the number of permutations consisting of 4 elements from the 12 elements described in the following data table:
PERMUTATIONA function - The function returns the number of permutations (can be repeated) of a given object in Excel Picture 2
- In the cell to calculate, enter the formula : = PERMUTATIONA (E6, E7)
PERMUTATIONA function - The function returns the number of permutations (can be repeated) of a given object in Excel Picture 3
- Press Enter -> The number of permutations includes 4 elements:
PERMUTATIONA function - The function returns the number of permutations (can be repeated) of a given object in Excel Picture 4
- Because the number of elements in permutations can be repeated, the case of number (number of objects)
PERMUTATIONA function - The function returns the number of permutations (can be repeated) of a given object in Excel Picture 5
- Where number ≤ 0 or number_chosen <0 -> the function returns the #NUM! Error value
PERMUTATIONA function - The function returns the number of permutations (can be repeated) of a given object in Excel Picture 6
Above are instructions and some specific examples when using PERMUTATIONA function in Excel.
Good luck!
You should read it
- PERMUT function - The function returns the number of permutations of a given number of objects in Excel
- MODE.SNGL function - Function that returns the most frequently occurring, or the most repeated values in an array or data range in Excel
- The object () function in Python
- COUPNUM function - The function returns the number of interest payments on a security in Excel
- RANK.AVG function - The function returns the rank of a number in a list of numbers in Excel
- Int () function in Python
- The DAYS function - The function returns the number of days between 2 dates in Excel
- GAMMA function - The function returns the gamma function value in Excel
- POISSON.DIST function - The function returns the Poisson distribution in Excel
- ISODD function - The function returns True if the value is an odd number in Excel
- POISSON function - The function returns the Poisson distribution in Excel
- BETA.DIST function - The function returns the Beta distribution in Excel
May be interested
PHI function - The function returns the value of the density function for a normal distribution in Excel
POISSON.DIST function - The function returns the Poisson distribution in Excel
QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excel
QUARTILE.INC function - The function returns the quartile of a dataset including values 0 and 1 in Excel
RANK.AVG function - The function returns the rank of a number in a list of numbers in Excel
RSQ - The function returns the square of the Pearson torque correlation coefficient in Excel