【函中201301班】第九讲作业B组上交贴

hwc2ycy

1、本贴已设置回贴仅作者可见，直接跟贴回复即可；
2、上交时直接贴公式，只上传附件的不予批改；
3、答题时必须注明【函中201301班】-组号-论坛ID,如【函中201301班】- B31-feedyu；
4、截止时间2013年7月4日17:00
5、请误重复占楼，非本组同学跟贴回复者扣分。

下附课程相关链接:
函中201301班第九讲课件

lyf7276

1、IF(LEN(SUBSTITUTE(NUMBERSTRING((B94),3),"○","零"))=7,SUBSTITUTE(NUMBERSTRING((B94),3),"○","零"),"零"&SUBSTITUTE(NUMBERSTRING((B94),3),"○","零"))
2、TEXT(SUM((FIND(MID(B102,ROW($A$1:$A$7),1),"零一二三四五六七八九")-1)*(10^(7-ROW($A$1:$A$7)))),"0000000")
3、NUMBERSTRING(F107,3)
4、IFERROR(MATCH(C115,NUMBERSTRING(ROW($A$1:$A$1500),1),),MATCH("一"&C115,NUMBERSTRING(ROW($A$1:$A$1500),1),))
5、LEFT(B124,2*LEN(B124)-LENB(B124))
6、MID(B131,FIND("市",B131)+1,SEARCHB("?",B131)/2-FIND("市",B131))

云影

【函中201301班】- B15-云影

1.

1. =TEXT(LEFT(B94,LEFT(B94)="0"),"[DBNUM2]")&SUBSTITUTE(NUMBERSTRING(B94,3),"○","零")

复制代码

2.

1. =IF(LEFT(B100)="零",0,"")&SUM((MATCH(MID(B100,ROW($1:$7),1),TEXT(ROW($1:$10)-1,"[DBNUM1];;零"),)-1)*10^(7-ROW($1:$7)))

复制代码

3.

1. =NUMBERSTRING(C107,3)

复制代码

4.

1. =MATCH("*"&C115,NUMBERSTRING(ROW($1:$1000),1),)

复制代码

5.

1. =LEFT(B124,LEN(B124)*2-LENB(B124))

复制代码

6.

1. =MID(LEFTB(B131,SEARCHB("?",B131)-1),FIND("市",B131)+1,99)

复制代码

opqazxc

【函中201301班】- B18-opqazxc
1

1. =RIGHT(SUBSTITUTE(NUMBERSTRING(1&B94,3),"○","零"),7)

复制代码

2数组公式

1. =TEXT(SUM((FIND(MID(B100,ROW($1:7),1),"零一二三四五六七八九")-1)*10^(7-ROW($1:7))),"0000000")

复制代码

3

1. =NUMBERSTRING(C107,3)

复制代码

4数组公式，最大就1000，也就到1000，可以引用整列

1. =MATCH("*"&C115,NUMBERSTRING(ROW($1:1000),1),)

复制代码

5

1. =LEFT(B124,2*LEN(B124)-LENB(B124))

复制代码

6

1. =MID(LEFT(B131,SEARCHB("?",B131)/2),FIND("市",B131)+1,9)

复制代码

wangjianff

第一题：

1. =MID(SUBSTITUTE(NUMBERSTRING(1&B94,3),"○","零"),2,15)

复制代码

第二题：

1. {=TEXT(SUM(MOD(FIND(MID(SUBSTITUTE(B100,"零","○"),ROW($1:$7),1),NUMBERSTRING(1234567890,3)),10)*10^(7-ROW($1:$7))),"0000000")}

复制代码

第三题：

1. =NUMBERSTRING(ROUND(C107,0),3)

复制代码

第四题：

1. {=MATCH(C115,TEXT(ROW($1:$2000),"[<20][DBNUM1][$-411]G/通用格式;[DBNUM1][$-804]G/通用格式"),)}

复制代码

第五题：

1. =LEFT(B124,2*LEN(B124)-LENB(B124))

复制代码

第六题：

1. =MIDB(B131,FINDB("市",B131)+1,SEARCHB("?",B131)-FINDB("市",B131)-1)

复制代码

【函中201301班】- B12-wangjianff

zx_wl

【函中201301班】- B05-zx_wl
1、

1. RIGHT(SUBSTITUTE(NUMBERSTRING(1&B94,3),"○","零"),7)

复制代码

2、

1. {=RIGHT(MATCH(SUBSTITUTE(LEFT("一"&B100,4),"零","○"),NUMBERSTRING(ROW($1:$9999),3),)*10^4+MATCH(SUBSTITUTE(RIGHT(B100,4),"零","○"),NUMBERSTRING(ROW($1:$9999),3),),7)}

复制代码

3、

1. =NUMBERSTRING(ROUND(C107,0),3)

复制代码

4、

1. {=MATCH(IF(LEFT(C115)="十",SUBSTITUTE(C115,"十","一十"),C115),NUMBERSTRING(ROW($1:$1000),1),)}

复制代码

5、

1. =LEFT(B124,LEN(B124)*2-LENB(B124))

复制代码

6、

1. {=MID(B131,FIND("市",B131)+1,LOOKUP(99,SEARCH(CHAR(ROW($65:$90)),B131))-FIND("市",B131)-1)}

复制代码

MYHERE131

【函中201301班】- B02-MYHERE131
第三题：=NUMBERSTRING(ROUND(C107,0),3)
第五题：=MIDB(B124,SEARCHB("?",B124),LEN(B124)*2-LENB(B124))
第六题：=MID(B131,FIND("市",B131)+1,SEARCHB("?",B131)/2-FIND("市",B131))

gaawx

1、=NUMBERSTRING(B94,3)
别的不会做

风花雪月8888

5、=MIDB(B124,SEARCHB("?",B124),LEN(B124)*2-LENB(B124))


【函中201301班】- B19-风花雪月8888

stone1969

第一题 =SUBSTITUTE(IF(LEFT(B3,1)="0","零"&(NUMBERSTRING($B3,3)),NUMBERSTRING($B3,3)),"○","零")
           =IF(LEFT(B3,1)="0","零"&(SUBSTITUTE(NUMBERSTRING(B3,3),"○","零")),SUBSTITUTE(NUMBERSTRING (B3,3),"○","零"))
第二题  =TEXT(SUM((FIND(MID(B9,ROW($1:$7),1),"零一二三四五六七八九")-1)*10^(7-ROW($1:$7))),REPT(0,7))
第三题 =NUMBERSTRING(ROUND(C16,0),3)
第四题 =MATCH(C24,SUBSTITUTE(SUBSTITUTE(NUMBERSTRING(ROW($1:$10000),1),"○","零"),IF(LEN(C24)=2,"一十",""),IF(LEN(C24)=2,"十","")),0)
第五题 =MIDB(B33,SEARCHB("?",B33),LEN(B33)*2-LENB(B33))
第六题 =MID(B40,FIND("市",B40)+1,SEARCHB("?",B40)/2-FIND("市",B40))