I know what they meanPERMUTATION 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.

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


"FC" wrote in message
...
I know what they meanPERMUTATION 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.

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

--
HTH :)
Dana DeLouis


"FC" wrote in message
...
I know what they meanPERMUTATION 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.

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.
"MartinW" wrote:

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


"FC" wrote in message
...
I know what they meanPERMUTATION 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.