PERMUT function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Spreadsheet Lookup functions
Measures of dispersion / spread
Probability and statistics
Correlation and line fitting
See also (in the Arrays Functions category); GROWTH, LINEST, LOGEST, TREND
Ranking
PERMUT
Returns the number of ordered permutations for a given number of objects.
Syntax:
PERMUT(n; k)
- where n and k are integers.
- PERMUT returns the number of ordered ways that k objects can be chosen from a set of n objects, where an object can only be chosen once. For example with a set of 3 objects A, B, C, we can choose 2 as follows: AB, AC, BA, BC, CA, CB.
- PERMUT calculates:
Example:
PERMUT(3; 2)
- returns 6, as in the example above.
Issues:
- The international standard ODFF expects n and k to be integers. Both Calc and Excel truncate any non-integer parameter.
See Also
