Table of Contents
This guide explains how to use PERMUTATIONA Function in Excel, including its syntax, required arguments, practical examples, and common errors.
Description: The function returns the number of permutations (iterations) of a given object. Support functions from Excel 2013 onwards.
Syntax: PERMUTATIONA (number, number_chosen)
Inside:
- number: Integer specifies the number of objects, is the required parameter .
- number_chosen: An integer that specifies the number of objects in a permutation, which is a required parameter.
Attention:
- If number, number_chosen are not whole numbers -> they are truncated to whole numbers.
- If number, number_chosen are not numbers -> the function returns the #VALUE! Error value
- If number ? 0 or number_chosen <0 -> the function returns the #NUM! Error value
For example:
Find the number of permutations consisting of 4 elements from the 12 elements described in the following data table:
- In the cell to calculate, enter the formula : = PERMUTATIONA (E6, E7)
- Press Enter -> The number of permutations includes 4 elements:
- Because the number of elements in permutations can be repeated, the case of number (number of objects) the function still calculates and returns the correct value:
- Where number ? 0 or number_chosen the function returns the #NUM! Error value
Above are instructions and some specific examples when using PERMUTATIONA function in Excel.
Good luck!
FAQ
What does the PERMUTATIONA function do in Excel?
The PERMUTATIONA function performs the calculation described in this guide. Use the correct arguments and compatible data types for reliable results.
How do I enter the PERMUTATIONA function correctly?
Start with an equals sign, enter PERMUTATIONA, add the required arguments inside parentheses, and confirm that cell references and separators are correct.
Why does the PERMUTATIONA function return an error?
Common causes include missing arguments, invalid data types, incorrect cell references, unsupported values, or regional separator settings.
Reader Comments 0
Sign in with email or Google to join the discussion.