[答题送BB,金币还未送完] 模拟XOR

willin2000 · 发表于 2008-6-5 22:27

求C1公式, C1 类似= A1 XOR B1. 蓝色是C1公式下拉结果.<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;">1 </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;">2 </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;">3 </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;">3 </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;">2 </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;">1 </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;">3 </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;">1 </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;">2 </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;">123456789012345 </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;">654321078910156 </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;">601782790644661 </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;">236545 </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;">45632323435345 </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;">45632323462992 </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;">345645 </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;">47776 </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;">392333 </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;">3 </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;">1 </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;">2 </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;">4 </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;">6 </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;">2 </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;">7 </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;">7 </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;">0 </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;">9 </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;">6 </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;">15 </td></tr></tbody></table>XOR 是异或运算, 0 XOR 1 =1, 1 XOR 1 =0, 0 XOR 0=09 XOR 6= 10010110 XOR--------1111=15A, B是最大为15位的正整数(为方便考虑,其实负数也可以). 题很简单,希望公式不要太长.用公式答题,不作任何设置,不用定义名称,不用复制列.为使思路不受限制字符数的影响, 字符数的要求采用的回复可见的方式. 每人只有一次答题机会.送BB规则:.只送答案正确并且字符数(不含数组符号,含=)少于M个字符的前4位得2个BB. 第一位答出字符数(不含数组符号,含=)少于N个字符的正确答案,再额外多得2个BB.M是:

游客，如果您要查看本帖隐藏内容请回复

N是:

游客，如果您要查看本帖隐藏内容请回复

[此贴子已经被作者于2008-6-7 11:18:16编辑过]

7dong502 · 发表于 2008-6-5 22:59

[em02]币币?

小笨蛋 · 发表于 2008-6-5 23:08

不知道XOR是什么?[em04]

小鲤鱼 · 发表于 2008-6-5 23:22

游客，如果您要查看本帖隐藏内容请回复

一剑惊心 · 发表于 2008-6-6 08:16

XOR是VBA里的函数？

my884813 · 发表于 2008-6-26 20:37

i want to know about the answer

tashanfan · 发表于 2008-8-3 11:30

我问问怎么获得金币

clx537697 · 发表于 2008-8-7 09:40

通  知（一）    请群里的女同志,准备好一寸彩照,身份证复印件,学历复印件,个人简历,送到国家航天局,据可靠消息,为庆祝七夕,要招聘嫦娥!（自带兔子） 通  知（二）    请群里的男同志,准备好一寸彩照,身份证复印件,学历复印件,个人简历,送到国家航天局,据可靠消息,为庆祝七夕,要招聘天蓬元帅（自带钉耙)

clx537697 · 发表于 2008-8-7 09:42

?0090

clx537697 · 发表于 2008-8-7 09:42

10094

		自动登录	找回密码
密码			注册