Microsoft® Excel® 2010 Formulas & Functions Inside Out
by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access