PERMUT Excel Formula

Author Zaheer    Category Formulas     Tags ,

Excel Statistical Function allows you to do simple to complex statistical computations: from mean, median, and mode to probability tests. The Statistical Function is composed of five subgroups. Under the subgroups is PERMUT Function. PERMUT function allows you to compute how many permutations do a given value of objects has. As an overview permutation is the significance of an internal order of a group of events or objects. This function is commonly used in calculating the probability of lottery results.

The syntax of PERMUT function include:

=PERMUT (number,number_chosen)

…whereas the argument Number is a numerical value that describes how many are the objects. The argument Number­_chosen is a value that corresponds to how many the objects are in a given permutation.

Test the function by opening a blank Excel worksheet or spreadsheet and input the following data in the source cells. For cell A1 input 100, for cell A2 input 3 and the formula is =PERMUT (A2, A3) and the result will be 970200. The result refers to the possible permutations with the data given. You can also immediately input the values in the function as: =PERMUT (49, 6) and the result will be 10,068,347,520.

For PERMUT function, there are common errors that will occur and these are #VALUE! error and #NUM! Errors. #VALUE! Error occurs when the argument Numbers or Number_chosen are non-numerical values. #NUM! error will occur if the argument number is equavalent to or lesser than zero and if Number_chosen arguments is lesser than 0. Likewise, if the argument Number is lesser than the argument Number_chosen #NUM! Error will also occur. In addition, take heed that the arguments if function is shortened and made into integers.

Once you have inputted the formula in the selected cell the result will automatically show. If you like to view the formula of the results you can hit Ctrl+` (grave accent) in the keys. In addition, you can do this by selecting Formulas tab hit the Formulas Auditing group and in the options select the Show Formula.

Post comment