Saturday 25 March 2017

Excel - Microsoft Excel PERMUTATIONA Function

Description

Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects.

Syntax

PERMUTATIONA(number, number-chosen)

The PERMUTATIONA function syntax has the following arguments:
  • Number    Required. An integer that describes the total number of objects.
  • Number_chosen    Required. An integer that describes the number of objects in each permutation.

PERMUTATIONA uses the following equation:

Remarks


Example

The workbook below shows examples of this function. Inspect them, change existing formulas, or enter your own formulas to learn how the function works.

No comments:

Post a Comment