View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default PERMUTATION AND COMBINATION

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.