Statistical
Excel 2013
◉ 10 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 — Coming soon
▦ 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
فرض کنید ۳ شیء در گروه وجود دارد، [۴،۵،۶]. با استفاده از PERMUTATIONA با ۲ شیء از ۳ شیء، ۹ حالت برای چیدمان اعداد با تکرار وجود دارد:
=PERMUTATIONA(3,2)
فرض کنید ۲ شیء در گروه وجود دارد، [۳،۵]. با استفاده از PERMUTATIONA با هر دو شیء، ۴ حالت برای چیدمان اعداد با تکرار وجود دارد:
=PERMUTATIONA(2,2)
✦ 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!