Table of Contents
This guide explains how to use PERMUT Function in Excel, including its syntax, required arguments, practical examples, and common errors.
Description: The function returns the number of permutations of a given object. Permutations are subsets of values where the position and number of elements in permutations are different.
Syntax: PERMUT (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 the function returns the #NUM! Error value
- If number ? 0 or number_chosen the function returns the #NUM! Error value
- The equation for numbers and permutations is:
[{P_ {k, n}} = frac {{n!}} {{Left ({n - k} right)!}}]
For example:
Find the number of permutations consisting of 4 elements from 93 elements described in the following data table:
- In the cell to calculate enter the formula : = PERMUT (E6, E7)
- Press Enter -> The number of permutations includes 4 elements:
- Where number (number of objects) function returns the #NUM! Error value
- Where number ? 0 or number_chosen the function returns the #NUM! Error value
Above are instructions and some specific examples when using PERMUT function in Excel.
Good luck!
FAQ
What does the PERMUT function do in Excel?
The PERMUT function performs the calculation described in this guide. Use the correct arguments and compatible data types for reliable results.
How do I enter the PERMUT function correctly?
Start with an equals sign, enter PERMUT, add the required arguments inside parentheses, and confirm that cell references and separators are correct.
Why does the PERMUT 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.