PERMUTATIONA Function in Excel: Syntax, Examples and Free Practice
PERMUTATIONA is an Excel Statistical function. Returns the number of permutations, allowing repeats.
PERMUTATIONA syntax
Arguments
number: A number to use in the calculationnumber_chosen: How many items are chosen at a time
When to use PERMUTATIONA
PERMUTATIONA is used in data analysis work to summarize or test patterns across a data set.
Practice PERMUTATIONA online, free
Open the live Excel-style spreadsheet and try PERMUTATIONA yourself. No Excel install or sign-up needed to start.
Practice PERMUTATIONA now →More Statistical functions
Frequently asked questions
What does the PERMUTATIONA function do in Excel?
Returns the number of permutations, allowing repeats.
What is the syntax of PERMUTATIONA in Excel?
The syntax is =PERMUTATIONA(number, number_chosen). number: A number to use in the calculation; number_chosen: How many items are chosen at a time.
Where can I practice PERMUTATIONA online for free?
Open the free live spreadsheet on Cellgrids and try PERMUTATIONA yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Statistical functions · Excel case studies · Excel tutorials · Excel shortcuts