What is the syntax for PERMUTATIONA in Excel?

The syntax for PERMUTATIONA is: =PERMUTATIONA(number, number_chosen)

How do I use the PERMUTATIONA function?

To use PERMUTATIONA, type =PERMUTATIONA( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.

What happens if PERMUTATIONA encounters errors?

If PERMUTATIONA encounters invalid arguments or calculation errors, it may return error values like #VALUE!, #NUM!, or #DIV/0!. Check your input values and ensure they meet the function's requirements.

Why is PERMUTATIONA not working in my Excel?

Common issues with PERMUTATIONA include #NUM! if parameters invalid. Start by checking the syntax =PERMUTATIONA(number, number_chosen), then verify each referenced cell or range.

Math & Trig

PERMUTATIONA Function in Excel

Returns the number of permutations with repetitions.

Syntax

=PERMUTATIONA(number, number_chosen)

Arguments

number (required): Total number of objects
number_chosen (required): Objects in each permutation

Examples

=PERMUTATIONA(3, 2) - Permutations with repetition - Result: 9

PERMUTATIONA in reporting workflows

Use absolute references when copying formulas across rows.
For conditional totals see [SUMIF](/functions/sumif/) and [SUMIFS](/functions/sumifs/).
Filtered lists may need [SUBTOTAL](/functions/subtotal/) instead of SUM on visible cells only.

Common errors

#NUM! if parameters invalid

Use cases

Probability with replacement
PIN codes
Combinations

Frequently asked questions

What is the PERMUTATIONA function in Excel? PERMUTATIONA returns the number of permutations with repetitions. The syntax is =PERMUTATIONA(number, number_chosen). Typical use cases include probability with replacement, pIN codes, combinations.
How do I use the PERMUTATIONA function? To use PERMUTATIONA, type =PERMUTATIONA( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
What happens if PERMUTATIONA encounters errors? If PERMUTATIONA encounters invalid arguments or calculation errors, it may return error values like #VALUE!, #NUM!, or #DIV/0!. Check your input values and ensure they meet the function's requirements.
Why is PERMUTATIONA not working in my Excel? Common issues with PERMUTATIONA include #NUM! if parameters invalid. Start by checking the syntax =PERMUTATIONA(number, number_chosen), then verify each referenced cell or range.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.