<p>求C1公式, C1 类似= A1 XOR B1. 蓝色是C1公式下拉结果.</p><p><table cellspacing="0" cellpadding="0" width="345" border="0" xstr="" style="WIDTH: 258pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="3" width="115" style="WIDTH: 86pt; mso-width-source: userset; mso-width-alt: 4906;"></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col></colgroup><tbody><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" align="right" width="115" height="15" xnum="1" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 86pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">1 </font></td><td class="xl24" align="right" width="115" xnum="2" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 86pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">2 </font></td><td class="xl25" align="right" width="115" xnum="3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 86pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff;"><font face="宋体" size="2">3 </font></td></tr><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" align="right" height="15" xnum="3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">3 </font></td><td class="xl24" align="right" xnum="2" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">2 </font></td><td class="xl25" align="right" xnum="1" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff;"><font face="宋体" size="2">1 </font></td></tr><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" align="right" height="15" xnum="3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">3 </font></td><td class="xl24" align="right" xnum="1" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">1 </font></td><td class="xl25" align="right" xnum="2" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff;"><font face="宋体" size="2">2 </font></td></tr><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" align="right" height="15" xnum="123456789012345" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">123456789012345 </font></td><td class="xl24" align="right" xnum="654321078910156" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">654321078910156 </font></td><td class="xl25" align="right" xnum="601782790644661" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff;"><font face="宋体" size="2">601782790644661 </font></td></tr><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" align="right" height="15" xnum="236545" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">236545 </font></td><td class="xl24" align="right" xnum="45632323435345" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">45632323435345 </font></td><td class="xl25" align="right" xnum="45632323462992" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff;"><font face="宋体" size="2">45632323462992 </font></td></tr><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" align="right" height="15" xnum="345645" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">345645 </font></td><td class="xl24" align="right" xnum="47776" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">47776 </font></td><td class="xl25" align="right" xnum="392333" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff;"><font face="宋体" size="2">392333 </font></td></tr><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" align="right" height="15" xnum="3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">3 </font></td><td class="xl24" align="right" xnum="1" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">1 </font></td><td class="xl25" align="right" xnum="2" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff;"><font face="宋体" size="2">2 </font></td></tr><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" align="right" height="15" xnum="4" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">4 </font></td><td class="xl24" align="right" xnum="6" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">6 </font></td><td class="xl25" align="right" xnum="2" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff;"><font face="宋体" size="2">2 </font></td></tr><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" align="right" height="15" xnum="7" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">7 </font></td><td class="xl24" align="right" xnum="7" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">7 </font></td><td class="xl25" align="right" xnum="0" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff;"><font face="宋体" size="2">0 </font></td></tr><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" align="right" height="15" xnum="9" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">9 </font></td><td class="xl24" align="right" xnum="6" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">6 </font></td><td class="xl25" align="right" xnum="15" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff;"><font face="宋体" size="2">15 </font></td></tr></tbody></table></p><p>XOR 是异或运算, 0 XOR 1 =1, 1 XOR 1 =0, 0 XOR 0=0</p><p>9 XOR 6= </p><p>1001</p><p>0110 XOR</p><p>--------</p><p>1111=15</p><p>A, B是最大为15位的正整数(为方便考虑,其实负数也可以). </p><p>题很简单,希望公式不要太长.</p><p>用公式答题,不作任何设置,不用定义名称,不用复制列.</p><p>为使思路不受限制字符数的影响, 字符数的要求采用的回复可见的方式. 每人只有一次答题机会.</p><p>送BB规则:.只送答案正确并且字符数(不含数组符号,含=)少于M个字符的前4位得2个BB. 第一位答出字符数(不含数组符号,含=)少于N个字符的正确答案,再额外多得2个BB.</p><p>M是:</p><p></p><p>N是:</p><p></p>
[此贴子已经被作者于2008-6-7 11:18:16编辑过] |