函快五班练习题六

helingping

=IF(TEXT(MOD((TEXT(MID(B2,10,9),"000000000")+TEXT(MID(B3,10,9),"000000000")),1000000000),"000000000")>1000000000,TEXT(MID(B2,1,9),"000000000")+TEXT(MID(B3,1,9),"000000000")+INT((TEXT(MID(B2,10,9),"000000000")+TEXT(MID(B3,10,9),"000000000"))/1000000000),TEXT(MID(B2,1,9),"000000000")+TEXT(MID(B3,1,9),"000000000"))&TEXT(MOD((TEXT(MID(B2,10,9),"000000000")+TEXT(MID(B3,10,9),"000000000")),1000000000),"000000000")

helingping

=TEXT(MID(B2,1,9),"000000000")+TEXT(MID(B3,1,9),"000000000")+IF((TEXT(MID(B2,10,1),"0")+TEXT(MID(B3,10,1),"0"))>9,1,0)&RIGHT((TEXT(MID(B2,10,9),"000000000")+TEXT(MID(B3,10,9),"000000000")),9)

海滨音诗

=LEFT(SUM(--C2:C3),15)&SUM((--RIGHT(C2:C3,3)))数组

翰墨水木

=LEFT(B2,15)*2&SUM(--RIGHT(B2:B3,3))    偷个鸡！

北京西单

北京西单 发表于 2011-12-12 22:44
第一次就题目解题 没考虑通用性，看看这次成么

暂时想不到了 等开贴看答案了

翰墨水木

=LEFT(SUM(INT((MID($B$2,ROW(INDIRECT("1:18")),1)+MID($B$3,ROW(INDIRECT("1:18")),1)))*(10^(18-ROW($1:18)))),LEN(B3)-4)&SUM(--RIGHT(B2:B3,4))  数组

海滨音诗

海滨音诗 发表于 2011-12-13 09:51
=LEFT(SUM(--C2:C3),15)&SUM((--RIGHT(C2:C3,3)))数组

=(LEFT(SUM(--B2:B3),15)+INT(SUM(--RIGHT(B2:B3,3))/1000)&MOD(SUM(--RIGHT(B2:B3,3)),1000))数组公式，这样应该不会错了吧,公式太长了。

zhangred

这么复杂哈，学习了。

清风霞影

=LEFT(B2+B3,15)&RIGHT(RIGHT(B2,3)+RIGHT(B3,3),3)

{:331:}

mfksypss

交卷，请批阅指正