Suppose there are 2 objects in the group. Since the two 5 factorials factor out into one you are left with 8 7 6, and when you multiply those terms together you have your answer. You can see this result in cell D8 in the. This equation equals out to be 8 7 6 5/5. For -example, to calculate 3-number permutations for the numbers 0-9, there are 10 numbers and 3 chosen, so the formula is: PERMUTATIONA (10,3) // returns 1000. Using PERMUTATIONA with 2 of the 3 objects, there are 9 ways the numbers can be arranged with repetition: To use PERMUTATIONA, specify the total number of items and ' numberchosen ', which represents the number of items in each combination. Suppose there are 3 objects in the group. If you need to, you can adjust the column widths to see all the data. For formulas to show results, select them, press F2, and then press Enter. If numeric arguments use data types that are nonnumeric, PERMUTATIONA returns the #VALUE! error value.Ĭopy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. If numeric arguments are values that are not valid, for example, when the total number is zero (0) and the chosen number is larger than zero (0), PERMUTATIONA returns the #NUM! error value.

PERMUTATIONA uses the following equation:īoth arguments are truncated to integers. An integer that describes the number of objects in each permutation. An integer that describes the total number of objects. The PERMUTATIONA function syntax has the following arguments: Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects.

This article describes the formula syntax and usage of the PERMUTATIONA function in Microsoft Excel.

Permutation formula