Buzz
As mentioned in the introduction, PERMUTATIONA is a computational function that produces the count of permutations for a given number of objects (with repetition), which can be chosen from the total number of objects. It's also one of the statistical functions widely used in Excel.
How to Use PERMUTATIONA in MS Excel
Excel's PERMUTATIONA Function
1. Syntax:
PERMUTATIONA(number, number_chosen)
Where:
- Number: Integer defining the quantity of objects, a required parameter.
- Number_chosen: Integer defining the quantity of objects in each permutation, a required parameter.
- The PERMUTATIONA function utilizes the following equation:
2. Important Considerations
- If Number or Number_chosen is not an integer -> they are truncated to integers.
- If Number or Number_chosen is not a numeric type -> the function returns the error value #VALUE!
- If Number ≤ 0 or Number_chosen < 0 -> the function returns the error value #NUM!
3. Illustrative Example
Calculate the permutations for a given number of objects (with repetition) that can be selected from the total number of objects.
Step 1: Enter the function syntax in cell C3 as follows:
Step 2: Press the Enter key to get the function result:
Step 3: Copy the function down to the cell below to get the corresponding result:
In the case of numeric arguments using non-numeric data types, the PERMUTATIONA function will result in an error value #VALUE! as shown below
If Number < 0 or Number_chosen < 0 -> the function returns the error value #NUM!
Above is a detailed guide on using PERMUTATIONA Function in Excel. We hope this article proves to be helpful for both your work and studies.
Additionally, don't overlook these common Excel functions:
- How to use Vlookup function, search function in excel
- How to use Index function in excel
- How to use And function in excel
If you find this helpful, feel free to share the article with your friends. Wishing you joy and success in your Excel endeavors.
