Manuals/calci/PERMUT

Revision as of 21:42, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''PERMUT'''(Number, NumberChosen) where, '''Number''' -  represents number of objects. '''NumberChosen'''...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

PERMUT(Number, NumberChosen)

where,

Number -  represents number of objects.

NumberChosen - represents the number of objects in  each permutation.


Returns the number of permutations of number of objects.A permutation is sset of objects or events where internal order is significant.Permutations are different from Combination, for which internal order is

not significant.

Formula:-

PERMUT = Pk,n = n!/(n-k)!


If  Number <=  0, PERMUT returns the #ERROR.

If Number < NumberChosen, it returns the #ERROR.

If Number or NumberChosen is nonnumeric ,it returns NaN


PERMUT


Lets see an example in (Column1, Row3)

=PERMUT(R1C1,R2C1)

PERMUT returns 1980.

Cosider an another example

=PERMUT(-50,8)

It returns #ERROR(Number =-50).


Syntax

Remarks

Examples

Description

Column1 Column2 Column3 Column4
Row1 45
Row2 2
Row3 1980
Row4
Row5
Row6