Thread: combinations
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bernd Bernd is offline
external usenet poster
 
Posts: 92
Default combinations

Hello,

You have 10 games with a possible result of 0 or 1,
so your result universe is
0000000000
0000000001
0000000010
0000000011
0000000100
....
1111111111
That makes 2^10. Just write into any cell
=2^10
which is 1024
Or take my UDF longbin2dec from http://www.sulprobil.com/html/
longdec2bin__.html:
=longbin2dec("10000000000")
which results in 1024 again.

Regards,
Bernd