An excel formula for combinations of 0 and 1? - formula to find all possible digit combinations
Is it possible, an excellent formula to give all possible combinations of 0 and 1, using or 20 decimal points?
Example:
Begin with 0:
0
1
00
01
10
11
000
001
010
011
111
110
101
100
.
.
.11111111111111111111
Is this possible?
Monday, February 15, 2010
Formula To Find All Possible Digit Combinations An Excel Formula For Combinations Of 0 And 1?
4 comments:
They recognize that there 1048576 combinations of twenty numbers 1-0
Put this in cell A1 (or any cell)
DEC2BIN = (ROW (A1) -1)
Copy and paste cell A1 to A2 to A512
DEC2BIN converts a binary number, the line (A1) -1 is a counter that by using the formula will be increased in each column.
DEC2BIN return only a maximum of eight binary digits. If you want an up to 20 numbers, put them into the A513, with a copy of the column. This applies to the amount of sixteen.
DEC2BIN = (INT (ROW (A512) / 512)) and DEC2BIN (ROW (A512)-INT (ROW (A512) / 512) * 512, 9)
DEC2BIN is part of the Excel "Data Analysis Tools Add-In
Tools for analyzing the impact
For Excel 2003:
http://office.microsoft.com / en-us / Excel / ...
For Excel 2007:
http://office.microsoft.com/en-us/excel/ ...
Possible, yes. Want to live to see completed to? Maybe. The score is extremely slow. Write it in VBA, and it is almost trivial. (20 binary digits 1048575 is therefore only say, from 0 to 1,048,575 from others and show each issue - in binary).
@ Colanth
In fact, ISH 2097151 numbers when you consider that the binary numbers with a length of 1 ~ 20, want to, including the bits on the left if it is 0. [(2 ^ 21) -1]
Yes, it is possible, albeit slowly, when you try to print them both.
Probably, but why would you do that?
Post a Comment