Hi Bernd --

Question going beyond your formula -- I am trying to find an additional
formula that looks at how many combinations of 2 digits or 3 digits or so
forth -- so if I had something where I had 5 things then I have 2^5-1 (I
don't use the 00000 in this case) 31 different combos. What I am trying to
figure out is that I know I have 31 combos, but the 31 combos come from 5
single digits (00001,00010,00100,01000,10000) and a bunch come from 2 digits
(00011,00101, etc). I am trying to figure out a formula for determining how
many 2 digits combos are possible, how many 1 digits are possible, 3 digits,
etc.

If you know off the top of your head I would appreciate the help --

Thank you --

Jim

"Bernd" wrote:

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