Thread: combinations
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default combinations

Thank you David. The link did not seem to be far enough along for it to
have been hit by a line wrap but then there no other*break-point* Also the
full colon after the 2nd html fooled me into thinking that that line
referred to the text below it.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"David Biddulph" wrote in message
...
I think you've only looked at half of the url, Sandy. It is:
http://www.sulprobil.com/html/longdec2bin__.html
--
David Biddulph

"Sandy Mann" wrote in message
...

Bernd,

Your link return a *Page not found* for me


"Bernd" wrote in message
ups.com...
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