PERMUT Function

Basic Description

The Excel PERMUT function calculates the number of permutations of a specified number of objects from a set of objects.

Syntax: PERMUT( number, number_chosen )

Where the function arguments are:

number The total number of objects available
number_chosen The number of objects in each permutation (i.e. the number selected from the total set)

 

Permut Function Examples

 Formulas:

Examples of use of the Excel Permut Function

 Results:

Excel Permut Function Results

The spreadsheet on the right shows several examples of the Excel Permut function used to show the number of permutations of six objects, selected from different sized object sets. The format of the functions are shown in the top spreadsheet and the resulting values are shown in the spreadsheet below.

 

Permut Function Errors

If you get an error from the Excel Permut Function, this is likely to be one of the following:

#NUM! Occurs if either the supplied number ≤ 0 or the supplied number_chosen < 0 the supplied number < number_chosen
#VALUE! Occurs if either the number or the number_chosen argument is non-numeric

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment