# How to Use PERMUTATIONA function in Google Sheets in 2020?

PERMUTATIONA functionThe PERMUTATIONA function returns the number of permutations for selecting a group of objects (with replacement) from a total number of objects. Mathematically, it is equivalent to raising the total number of objects to the number of objects being chosen.

Parts of a PERMUTATIONA function

PERMUTATIONA(number, number_chosen)

Part
Description

number
Required. The total number of objects to choose from.

number_chosen
Required. The number of objects to choose from number. Must be less than or equal to number.

Notes

Both arguments are truncated to integers.
If the number is zero, PERMUTATIONA returns a #NUM.

Examples

Result for A1=PERMUTATIONA(3, 2), A2=PERMUTATIONA(3.2, 2), A3= PERMUTATIONA(3, 2.4).

Note: All functions return the same result due to truncation.

A
B

1
PERMUTATIONA
Formula

2
99
=PERMUTATIONA(3, 2)

3
9

4
9
=PERMUTATIONA(3.2, 2.3)

Related functions

PERMUT: Returns the number of ways to choose some number of objects from a pool of a given size of objects, considering order.
COMBIN: The COMBIN function returns the number of ways to choose some number of objects from a pool of a given size of objects.
COMBINA: The COMBINA function returns the number of ways to choose some number of objects from a pool of a given size of objects, including ways to choose the same object multiple times (also known as choosing with replacement).

Categories Uncategorized