PERMUTATION AND COMBINATION

[Guest]

I know what they mean>>PERMUTATION AND COMBINATION
There is a lot of question about it in discussion group but no answer for
this simple question ( not even in www.mathworld.com... or other websides).
Can someone just offer a simple answer to this problem ?:
A1=52
B1=6
Need a formula for PERMUTATION of A1 and B1 to give result in C1(formula in
C1)
Need a formula for COMBINATION of A1 and B1 to give result in D1(formula in
D1).
Thanks.

 

[MartinW]

Hi FC,

Check out the PERMUT and COMBIN worksheet functions in the help file.
They explain them a lot better than I can here.

HTH
Martin

 

[Dana DeLouis]

this simple question ( not even in www.mathworld.com... or other

websides).

Hi. As a side note, Excel's "Combin" function is mathematically the
Binomial Function.

=COMBIN(52,6)
20,358,520

Binomial[52, 6]
20,358,520

http://mathworld.wolfram.com/BinomialCoefficient.html

http://mathworld.wolfram.com/Permutation.html

 

[Guest]

Thanks MartinW.
After doing some research I found out tha the answer is more simple than
anyone could it think of, and I'll share it with everyone ( probably now
everybody will say they knew ).Simple as this : Formula is :
=COMBIN(A1,B1)
=PERMUT(A1,B1)
Formula can be put in any cell to obtain the results.