[练习题]十进制转二进制

Luckyguy2008

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>不看不看</i>在2007-12-27 22:54:00的发言：</b><br/><table width="144" cellspacing="0" cellpadding="0" border="0" xstr="" style="width: 108pt; border-collapse: collapse;"><colgroup><col width="72" span="2" style="width: 54pt;"></col></colgroup><tbody><tr height="19" style="height: 14.25pt;"><td width="72" height="19" align="right" xnum="" style="border: medium none rgb(236, 233, 216); width: 54pt; height: 14.25pt; background-color: transparent;">1</td><td width="72" align="right" xnum="" style="border: medium none rgb(236, 233, 216); width: 54pt; background-color: transparent;">1</td></tr><tr height="19" style="height: 14.25pt;"><td height="19" align="right" xnum="" style="border: medium none rgb(236, 233, 216); height: 14.25pt; background-color: transparent;">2</td><td align="right" xnum="" style="border: medium none rgb(236, 233, 216); background-color: transparent;">10</td></tr><tr height="19" style="height: 14.25pt;"><td height="19" align="right" xnum="" style="border: medium none rgb(236, 233, 216); height: 14.25pt; background-color: transparent;">3</td><td align="right" xnum="" style="border: medium none rgb(236, 233, 216); background-color: transparent;">11</td></tr><tr height="19" style="height: 14.25pt;"><td height="19" align="right" xnum="" style="border: medium none rgb(236, 233, 216); height: 14.25pt; background-color: transparent;">4</td><td align="right" xnum="" style="border: medium none rgb(236, 233, 216); background-color: transparent;">100</td></tr><tr height="19" style="height: 14.25pt;"><td height="19" align="right" xnum="" style="border: medium none rgb(236, 233, 216); height: 14.25pt; background-color: transparent;">5</td><td align="right" xnum="" style="border: medium none rgb(236, 233, 216); background-color: transparent;">101</td></tr><tr height="19" style="height: 14.25pt;"><td height="19" align="right" xnum="" style="border: medium none rgb(236, 233, 216); height: 14.25pt; background-color: transparent;">6</td><td align="right" xnum="" style="border: medium none rgb(236, 233, 216); background-color: transparent;">110</td></tr><tr height="19" style="height: 14.25pt;"><td height="19" align="right" xnum="" style="border: medium none rgb(236, 233, 216); height: 14.25pt; background-color: transparent;">7</td><td align="right" xnum="" style="border: medium none rgb(236, 233, 216); background-color: transparent;">111</td></tr><tr height="19" style="height: 14.25pt;"><td height="19" align="right" xnum="" style="border: medium none rgb(236, 233, 216); height: 14.25pt; background-color: transparent;">8</td><td align="right" xnum="" style="border: medium none rgb(236, 233, 216); background-color: transparent;">1000</td></tr><tr height="19" style="height: 14.25pt;"><td height="19" align="right" xnum="" style="border: medium none rgb(236, 233, 216); height: 14.25pt; background-color: transparent;">9</td><td align="right" xnum="" style="border: medium none rgb(236, 233, 216); background-color: transparent;">1001</td></tr><tr height="19" style="height: 14.25pt;"><td height="19" align="right" xnum="" style="border: medium none rgb(236, 233, 216); height: 14.25pt; background-color: transparent;">10</td><td align="right" xnum="" style="border: medium none rgb(236, 233, 216); background-color: transparent;">1010</td></tr><tr height="19" style="height: 14.25pt;"><td height="19" align="right" xnum="" style="border: medium none rgb(236, 233, 216); height: 14.25pt; background-color: transparent;">11</td><td align="right" xnum="" style="border: medium none rgb(236, 233, 216); background-color: transparent;">1011</td></tr></tbody></table>这样对吗？</div><p></p><br/>[em17]

封州大少

<p>多单元格数组公式:</p><p>=TEXT(MMULT(MOD(INT(A1:A20/(2^(15-COLUMN(A:O)))),2),10^(15-ROW(1:15))),REPT(0,15))</p><p>82字符</p><p>=TEXT(MMULT(MOD(INT(A1:A20/TRANSPOSE(2^(15-ROW(1:15)))),2),10^(15-ROW(1:15))),REPT(0,15))</p><p>89字符</p><p>普通公式:</p><p>=TEXT(SUMPRODUCT(MOD(INT(A1/2^(15-ROW($1:$15))),2),10^(15-ROW($1:$15))),REPT(0,15))</p><p>83字符</p><p>都是换汤不换药,呵呵</p> aDtcxFsw.rar (2.93 KB, 下载次数: 25)

2008-1-1 23:23 上传

点击文件名下载附件
[练习题]十进制转二进制 <br/>

legend_chen

<p>好难啊</p>

sckc62

<p>用自定义数字格式，57字符就够了，数组公式：</p><p>B2=SUM(MOD(INT(A2/2^(ROW($1:$15)-1)),2)*10^(ROW($1:$15)-1))</p>

hai

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>liangwen</i>在2007-12-21 16:49:00的发言：</b><br/><p>俺数学只有小学生水平,不懂什么十进制二进制.56为会什么就是0000000000111000??</p>[em06]</div><p></p>&nbsp;&nbsp;&nbsp; 一样[em06]

szyygb

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>Luckyguy2008</i>在2007-12-21 20:33:00的发言：</b><br/>二进制再补充一下<br/><br/>下面例子左边二进制，右边十进制<br/>1=2^0=1<br/>10=2^1=1<br/>......<br/><br/></div><p>10=2^1=1 ？</p><p>应该是：10=2^1=2<br/></p>

bl5062

=DEC2BIN(A1:A20/2^9)*10^9+DEC2BIN(MOD(A1:A20,2^9))
貌似可以啊，我的2010版