PERMUT()

Syntax. PERMUT(number;number_chosen)

Definition. This function returns the number of permutations to query k elements from n elements. A permutation is a set of elements or events where the internal order is significant.

Arguments

  • number (required). The number of elements

  • number_chosen (required). Specifies the number of elements for a permutation

Note

Both arguments are truncated to integers.

If number or number_chosen isn’t a numeric value, the PERMUT() function returns the #VALUE! error. If number is less than or equal to 0, the PERMUT() function returns the #NUM! error. If number is less than number_chosen, the PERMUT() function returns the #NUM! error.

Background. The PERMUT() function belongs to combinatorics that determine the number of ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.