Statistical
Excel 2013
◉ 30 views
=PERMUTATIONA()
Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=PERMUTATIONA(number, number-chosen)
Hover argument names in the table for details.
Output typeNumber
Popularity5 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =PERMUTATIONA() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
number |
Number | Optional | NumberRequired. An integer that describes the total number of objects. |
number_chosen |
Number | Required | An integer that describes the number of objects in each permutation. |
▣ Examples
Suppose there are 3 objects in the group, [4,5,6]. Using PERMUTATIONA with 2 of the 3 objects, there are 9 ways the numbers can be arranged with repetition:
=PERMUTATIONA(3,2)
Result:
9
Suppose there are 2 objects in the group, [3,5]. Using PERMUTATIONA with both of the objects, there are 4 ways the numbers can be arranged with repetition:
=PERMUTATIONA(2,2)
Result:
4
§ Remarks
- Both arguments are truncated to integers.
- If numeric arguments are values that are not valid, for example, when the total number is zero (0) and the chosen number is larger than zero (0), PERMUTATIONA returns the #NUM! error value.
- If numeric arguments use data types that are nonnumeric, PERMUTATIONA returns the #VALUE! error value.
✦ Tips
- Both arguments are truncated to integers.
⚠ Common Errors
#NUM!
If numeric arguments are values that are not valid, for example, when the total number is zero (0) and the chosen number is larger than zero (0), PERMUTATIONA returns the #NUM! error value.
Fix: Correct the input value
#VALUE!
If numeric arguments use data types that are nonnumeric, PERMUTATIONA returns the #VALUE! error value.
Fix: برای هر دو آرگومان مقدار عددی وارد کنید و بررسی کنید سلولهای مرجع خالی یا متنی نباشند.
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!