【函中201301班】第九讲作业D组上交贴（已开帖）

lucking551

【函中201301班】- D05-lucking551
第一题：

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

复制代码

第二题：

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

复制代码

第三题：

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

复制代码

第四题：数组

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

复制代码

第五题：数组

1. =MID(B124,SMALL(IF(ISERROR(--MID(B124,ROW($1:$99),1)),"a",ROW($1:$99)),1),LEN(B124)*2-LENB(B124)-SMALL(IF(ISERROR(--MID(B124,ROW($1:$99),1)),"a",ROW($1:$99)),1)+1)

复制代码

第六题：

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

复制代码

lion_zjy

【函中201301班】-D10-lion_zjy

1.=MID(SUBSTITUTE(NUMBERSTRING(2&B94,3),NUMBERSTRING(0,3),"零"),2,16)

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

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

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

Shelvee

【函中201301班】- D15- Shelvee
3. =NUMBERSTRING(ROUND(C107,0),3)
5. =LEFT(B124,2*LEN(B124)-LENB(B124))
6. =MIDB(B131,FINDB("市",B131)+1,SEARCHB("?",B131)-FINDB("市",B131)-1)

yunqingzi

liziyuliziyu7 发表于 2013-7-1 12:42
【函中201301班】-d04-liziyuliziyu7
=IF(--RIGHT(B94)=0,SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(S ...

改为=IF(LEN(NUMBERSTRING(B94,3))<>LEN(B94),"零"&SUBSTITUTE(NUMBERSTRING(B94,3),"○","零"),SUBSTITUTE(NUMBERSTRING(B94,3),"○","零"))