【函中201301班】第一讲D组作业上交帖

hgzyc

【函中201301班]- D06-HGZYC
第一题：

1. =LEN(A3&A4&A5&A6&A7)-LEN(SUBSTITUTE((A3&A4&A5&A6&A7),"小妖",1))

复制代码

第二题：

1. =MID(A13&"# #",FIND("#",A13&"# #")+1,FIND("#",A13&"# #",FIND("#",A13&"# #")+1)-(FIND("#",A13&"# #")+1))

复制代码

第三题：

1. =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(NUMBERSTRING(ROUNDDOWN(ROUND(A23,1),0),2)&"元","零元","A")&SUBSTITUTE(TEXT(LEFT(RIGHT(ROUND(A23,1)+0.01,2),1),"[DBNum2]")&"角","零角","整"),"A整","零元整"),"A","")

复制代码

yanyupingsheng

【函中201301班】-D08-yanyupingsheng
1、

1. =(LEN(PHONETIC(A3:A7))-LEN(SUBSTITUTE(PHONETIC(A3:A7),"小妖","")))/2

复制代码

2、

1. =IFERROR(LEFT(IFERROR(MID(A13,FIND("#",A13)+1,99),""),FIND("#",IFERROR(MID(A13,FIND("#",A13)+1,99),""))-1),IFERROR(MID(A13,FIND("#",A13)+1,99),""))

复制代码

3、

1. =IFERROR(IF(MID(REPLACE(TEXT(ROUND(A23,1),"[DBNUM2]"),FIND(".",TEXT(ROUND(A23,1),"[DBNUM2]"))+2,,"角"),FIND(".",REPLACE(TEXT(ROUND(A23,1),"[DBNUM2]"),FIND(".",TEXT(ROUND(A23,1),"[DBNUM2]"))+2,,"角"))-1,1)="零",RIGHT(REPLACE(TEXT(ROUND(A23,1),"[DBNUM2]"),FIND(".",TEXT(ROUND(A23,1),"[DBNUM2]"))+2,,"角"),2),REPLACE(REPLACE(TEXT(ROUND(A23,1),"[DBNUM2]"),FIND(".",TEXT(ROUND(A23,1),"[DBNUM2]"))+2,,"角"),FIND(".",REPLACE(TEXT(ROUND(A23,1),"[DBNUM2]"),FIND(".",TEXT(ROUND(A23,1),"[DBNUM2]"))+2,,"角")),1,"元")),TEXT(ROUND(A23,1),"[DBNUM2]")&"元整")

复制代码

【函中201301班】-D08-yanyupingsheng

juguozun

【函中201301班】-D14-juguozun
练1  =SUM((LEN(A3:A7)-LEN(SUBSTITUTE(A3:A7,"小妖","")))/2)，ctrl+shift+enter三键结束
练2  =LEFT(MID(A13&"#",FIND("#",A13&"#")+1,99)&"#",FIND("#",MID(A13&"#",FIND("#",A13&"#")+1,99)&"#")-1)，下拉
练3 （选做题）=SUBSTITUTE(SUBSTITUTE(NUMBERSTRING(INT(A23),2)&"元"&IF(A23=INT(A23),"整",NUMBERSTRING(ROUND(((A23-INT(A23))*10),1),2)&"角"),"零元",""),"零角","零元整")，下拉

wangsunye3

请老师多批评，谢谢~

lion_zjy

函中201301班]- D10-lion_zjy

1.=LEN(A3&A4&A5&A6&A7)-LEN(SUBSTITUTE((A3&A4&A5&A6&A7),"小妖",0))

2.=MID(A13,FIND("#",A13)+1,FIND("#",A13,FIND("#",A13)+1)-FIND("#",A13)-1)

3.=NUMBERSTRING(INT(A23),2)&"元"&IF(A23=INT(A23),"整",NUMBERSTRING(INT((A23-INT(A23))*10),2)&"角")

cg372101

发错帖子了，sorry，删掉重发