PERMUT function
PERMUT counts how many ways you can pick and order some items from a larger set, such as podium finishes among runners. Order matters here, so use COMBIN when it does not.
Example
Read it as a sentence: count the ordered ways to pick 3 items from 10, which gives 720.
A
B
C
D
1
720
2
3
Syntax
PERMUT(number, number_chosen)
-
number(required) - Total items in the pool.
-
number_chosen(required) - Items in each arrangement.
Returns: The number of ordered arrangements without repetition.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=PERMUT(10,3) | 720 | Working example |
=PERMUT("10",3) | 720 | Text-number in first arg |
=PERMUT({10,10},3) | 720 | Array in first arg (lifts, spills) |
=PERMUT(10.9,3.9) | 720 | Fractions truncated |
=PERMUT(10,0) | 1 | Zero chosen |
=PERMUT("abc",3) | #VALUE! | Non-numeric text in first arg |
=PERMUT(NA(),3) | #N/A | Error in first arg |
=PERMUT(3,10) | #NUM! | Chosen > number |
Watch out for
- Order matters; use COMBIN when it does not.
- number_chosen larger than number gives #NUM!.
Where it works
- Excel
- PERMUT is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .