Home
Tech info
Technology
Science
Life
Application
Electric
Program
Mobile
Windows 10
Windows 11PERMUTATIONA 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.
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:
- In the cell to calculate, enter the formula : = PERMUTATIONA (E6, E7)
- Press Enter -> The number of permutations includes 4 elements:
- Because the number of elements in permutations can be repeated, the case of number (number of objects)
- Where number ≤ 0 or number_chosen <0 -> the function returns the #NUM! Error value
Above are instructions and some specific examples when using PERMUTATIONA function in Excel.
Good luck!
Isabella HumphreyYou should read it
- 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
May be interested
- SHEETS function - The function returns the number of pages in a reference in Excel
sheets function: the function returns the number of pages in a reference. support functions from excel 2013 onwards. syntax: sheets (reference) - BETA.DIST function - The function returns the Beta distribution in Excelbeta.dist function: the function returns the beta distribution to study the variability of a number of things through a sample. support functions from excel 2010 onwards. syntax: beta.dist (x, alpha, beta, cumulative, [a], [b])
- The SQRT function returns the square root of a positive number in Excelthe sqrt () function in excel helps you quickly calculate the square root of any number you want. the syntax and usage of the function is very simple, but if you do not know, follow the article below.
- How to use ADDRESS function in Excelthe address function in excel takes the number of rows and column numbers as arguments and returns the reference of the standard cell (cell address). for example, if you go to row 4 and column 3, the function returns c4.
- POISSON function - The function returns the Poisson distribution in Excelin predicting the number of events that occur within a specific time, one cannot help but use the poisson function. the following article details how to use the poisson function, the function returns the poisson distribution.
- MONTH function - The function returns the monthly value of a day expressed as a serial number in Excelmonth function: the function returns the month of a day expressed as serial number in excel. months are represented by integers with values between 1 and 12 months. syntax: month (serial_number)
- NETWORKDAYS function - The function returns the number of whole working days between 2 dates in Excelnetworkdays function: the function returns the number of intact working days calculated between two specific dates. working days do not include weekends and holidays specified. syntax: networkdays (start_date, end_date, [holidays])
- SHEET function - The function returns the worksheet number value of the referenced worksheet in Excelsheet function: the function returns the sheet number of the referenced worksheet. support functions from excel 2013 onwards. syntax: sheet (value)
- DAYS360 function - The function returns the number of days between 2 dates, based on 360 days in Exceldays360 function: the function performs the calculation of the number of days between 2 days, based on 360 days year (from 12 months, 30 days per month). useful function in calculating payments in the accounting system based on twelve months 30 days. syntax: days (start_date, end_date, [m
- TIME function - Function returns decimal numbers for a specific time value in Exceltime function: the function returns the decimal number for a time value. the decimal number that the function returns is from 0 to 0.99988426, which corresponds to the time from 0:00:00 (12:00:00 am) to 23:59:59 (11:59:59 pm). syntax: time (hour, minute, second)
Office information
- 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
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