【函中20130301】第九讲C组作业上交帖【开贴】

wangzan

第一题：=REPT("零",7-LEN(NUMBERSTRING(B94,3)))&SUBSTITUTE(NUMBERSTRING(B94,3),NUMBERSTRING("0",3),"零")
第二题：=TEXT(SUMPRODUCT((MATCH(MID(B100,ROW($1:$7),1),{"零","一","二","三","四","五","六","七","八","九"},)-1),(10^LARGE(ROW($1:$7),ROW($1:$7))/10)),"0000000")
第三题：=NUMBERSTRING(ROUND(C107,0),3)
第四题：=MATCH(IF(LEFT(C116,1)="十","一"&C116,C116),NUMBERSTRING(ROW($1:$1000),1),)
第五题：=MID(B124,1,LEN(B124)*2-LENB(B124))
第六题：=MID(B131,(FIND("市",B131)+1),(SEARCHB("?",B131)+1)/2-(FIND("市",B131)+1))
【函中201301班】-C09-wangzan

zhs5483

【函中201301班】-C11-zhs5483
1、①=SUBSTITUTE(IF(LEFT(B94,1)="0","○"&NUMBERSTRING(B94,3),NUMBERSTRING(B94,3)),"○","零")
  或②  =SUBSTITUTE(REPLACE(NUMBERSTRING(1&B94,3),1,1,),"○","零")
2、{=REPLACE(MATCH(SUBSTITUTE(LEFT("一"&B100,4),"零","○"),NUMBERSTRING(ROW($1:$2000),3),0)&MATCH(SUBSTITUTE(MID(B100,4,8),"零","○"),NUMBERSTRING(ROW($1:$9999),3),0),1,1,)}
3、 =NUMBERSTRING(C107,3)
4、{=MATCH(IF(LEFT(C115,1)="十","一"&C115,C115),NUMBERSTRING(ROW($1:$1000),1),0)}
5、 =LEFT(B124,LEN(B124)*2-LENB(B124))
6、 =MID(B131,SEARCH("市",B131)+1,(SEARCHB("?",B131)-SEARCH("市",B131)*2)/2)

yjeeee

【函中201301班】-C07-yjeeee
请学委点评：
1

1. =IF(LEFT(B94,1)="0","零"&SUBSTITUTE(NUMBERSTRING(B94,3),"○","零"),SUBSTITUTE(NUMBERSTRING(B94,3),"○","零"))

复制代码

2

1. =IF(LEFT(B100,1)="零","0"&MATCH(MID(SUBSTITUTE(B100,"零","○"),2,2),NUMBERSTRING(ROW($A$1:$A$10000),3),0)&MATCH(RIGHT(SUBSTITUTE(B100,"零","○"),4),NUMBERSTRING(ROW($A$1:$A$10000),3),0),MATCH(LEFT(SUBSTITUTE(B100,"零","○"),3),NUMBERSTRING(ROW($A$1:$A$10000),3),0)&MATCH(RIGHT(SUBSTITUTE(B100,"零","○"),4),NUMBERSTRING(ROW($A$1:$A$10000),3),0))

复制代码

3

1. =NUMBERSTRING(INT(C107+0.5),3)

复制代码

4

1. =MATCH(C115,TEXT(ROW($A$1:$A$1000),"[>20][DBNum1];[DBNum1]d"),0)

复制代码

5

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

复制代码

6

1. =MID(B131,FIND("市",B131)+1,IFERROR(SEARCH("A",B131),IFERROR(SEARCH("B",B131),SEARCH("C",B131)))-FIND("市",B131)-1)

复制代码

csmccdh

第一题：
方法一：=MID(SUBSTITUTE(NUMBERSTRING(1&B94,3),"○","零"),2,7)
方法二：=RIGHT(SUBSTITUTE(NUMBERSTRING(1&B94,3),"○","零"),7)
第二题：
=RIGHT(SUM((FIND(MID("一"&B100,ROW($1:$8),1),"零一二三四五六七八九")-1)*10^(8-ROW($1:$8))),7)（数组）
第三题：
=NUMBERSTRING(ROUND(C107,),3)
第四题
=MATCH(IF(LEFT(C115)="十","一",)&C115,TEXT(ROW($1:$1000),"[dbnum1]"),)（数组）
第五题：
=LEFT(B124,2*LEN(B124)-LENB(B124))
第六题
方法一：=MID(B131,FIND("市",B131)+1,(SEARCHB("?",B131)-FINDB("市",B131)-1)/2)
方法二：=MIDB(B131,FINDB("市",B131)+2,SEARCHB("?",B131)-FINDB("市",B131)-2)

一江秋水

函中201301班】-C03-一江秋水
作业1

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

复制代码

作业2

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

复制代码

作业3

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

复制代码

作业4

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

复制代码

作业5

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

复制代码

作业6

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

复制代码

孤单无所谓

3、

1. =SUBSTITUTE(TEXT(ROUND(C107,),"[dbnum1]"),"十","")

复制代码

4、

1. =IF(LEN(C115)=1,FIND(B2,"一二三四五六七八九"),IF(LEFT(C115)="十",FIND(RIGHT(C115),"一二三四五六七八九")+10,IFERROR(FIND(MID(C115,FIND("千",C115)-1,1),"一二三四五六七八九"),)*1000+IFERROR(FIND(MID(C115,FIND("百",C115)-1,1),"一二三四五六七八九"),)*100+IFERROR(FIND(MID(C115,FIND("十",C115)-1,1),"一二三四五六七八九"),)*10+IFERROR(FIND(RIGHT(C115),"一二三四五六七八九"),)))

复制代码

5、

1. =LEFT(B124,SUM(N(LENB(MID(B124,ROW($1:$66),1))=1)))

复制代码

6、

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

复制代码

xuyouxm

【函中201301班】-c21-xuyouxm

01:

1. =IF(LEFT(B94,1)="0","零"&(SUBSTITUTE(NUMBERSTRING(B94,3),"○","零")),SUBSTITUTE(NUMBERSTRING(B94,3),"○","零"))

复制代码

1. =SUBSTITUTE(IF(LEFT(B94,1)="0","○"&NUMBERSTRING(B94,3),NUMBERSTRING(B94,3)),"○","零")

复制代码

02:

1. =RIGHT(SUM(IFERROR((FIND(MID("一"&B100,ROW($1:$8),1),"一二三四五六七八九○")),0)*(10^(8-ROW($1:$8)))),7)

复制代码

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

复制代码

03:

1. =IF(NUMBERSTRING(ROUND(C107,0),3)="","○",NUMBERSTRING(ROUND(C107,0),3))

复制代码

04:

1. =IFERROR(MATCH(C115,NUMBERSTRING(ROW($1:$2000),1),),MATCH("一"&C115,NUMBERSTRING(ROW($1:$2000),1),))

复制代码

05:

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

复制代码

1. =MIDB(B124,SEARCHB("?",B124),LEN(B124)*2-LENB(B124))

复制代码

06:

1. =MID(B131,FIND("市",B131)+1,IF(ISNUMBER(SEARCH("?A?",B131)),SEARCH("?A?",B131),IF(ISNUMBER(SEARCH("?B?",B131)),SEARCH("?B?",B131),SEARCH("?C?",B131)))-FIND("市",B131))

复制代码

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

复制代码

womohe

函中201301-C18-womohe


1  =SUBSTITUTE(NUMBERSTRING(LEFT(B94),3)&NUMBERSTRING(RIGHT(B94,6),3),"○","零")
2 =TEXT(SUM((FIND(MID(B100,ROW($1:$7),1),"零一二三四五六七八九")-1)*(10^(7-ROW($1:$7)))),"0000000")
3 =NUMBERSTRING(ROUND(C107,),3)
4 =MATCH(SUBSTITUTE(SUBSTITUTE(C115,"一百","百"),"一千","千"),TEXT(ROW($1:$1000),"[dbnum1][$-411]G/通用格式"),)
5 =LEFT(B124,2*LEN(B124)-LENB(B124))
6 =MIDB(B131,MIN(SEARCHB({"市","?"},B131))+2,SUM(SEARCHB({"市","?"},B131)*{-1,1})-2)

不信这样不重名

9.rar (42.9 KB, 下载次数: 8)

2013-7-4 17:10 上传

点击文件名下载附件

365221582

学习一下。