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

007feiren

【函中201301班]- A22-007feiren:

1. ={SUM(LEN(A3:A7)-LEN(SUBSTITUTE(A3:A7,"小妖",0)))}

复制代码

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

复制代码

1. =IF(OR(NUMBERSTRING(INT(ROUND(A23,1)),2)&"元"&IF(ROUND(A23,1)=INT(ROUND(A23,1)),"整",NUMBERSTRING(INT((ROUND(A23,1)-INT(ROUND(A23,1))+0.001)*10),2)&"角")="零元整",LEFT(NUMBERSTRING(INT(ROUND(A23,1)),2)&"元"&IF(ROUND(A23,1)=INT(ROUND(A23,1)),"整",NUMBERSTRING(INT((ROUND(A23,1)-INT(ROUND(A23,1))+0.001)*10),2)&"角"),2)<>"零元"),G23,SUBSTITUTE(NUMBERSTRING(INT(ROUND(A23,1)),2)&"元"&IF(ROUND(A23,1)=INT(ROUND(A23,1)),"整",NUMBERSTRING(INT((ROUND(A23,1)-INT(ROUND(A23,1))+0.001)*10),2)&"角"),"零元",""))

复制代码

最后人民币大写选做题费了九牛二虎之力做出来了，不知可以不，请指导！

augustzhu1983

【函中201301班】-A08-augustzhu1983
第一题

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

复制代码

第二题

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

复制代码

第三题

1. =SUBSTITUTE(SUBSTITUTE(TEXT(INT(ROUND(A23,1)),"[dbnum2];; ")&"元"&TEXT(MOD(ROUND(A23,1),1)*10,"[dbnum2]0角;;整")," 元整","零元整")," 元",)

复制代码

rlz680926

【函中201301班]- A24
老师你好，中午作业没做好，下午搞了一下午，终于有所长时，现再耽误一下你的宝贵时间，烦请重新批一下。
       第一题：b3=(LEN(A3)-LEN(SUBSTITUTE(A3,"小妖",)))/2,下拉，sum(d3:d7)
       第二题：=IF(AND(IF(ISERROR(FIND("#",A13)),0,FIND("#",A13))=0,IFERROR(FIND("#",A13,(IF(ISERROR(FIND("#",A13)),0,FIND("#",A13))+1)),0)=0),"",IF(AND(IF(ISERROR(FIND("#",A13)),0,FIND("#",A13))<>0,IFERROR(FIND("#",A13,(IF(ISERROR(FIND("#",A13)),0,FIND("#",A13))+1)),0)=0),MID(A13,IF(ISERROR(FIND("#",A13)),0,FIND("#",A13))+1,99),MID(A13,IF(ISERROR(FIND("#",A13)),0,FIND("#",A13))+1,IFERROR(FIND("#",A13,(IF(ISERROR(FIND("#",A13)),0,FIND("#",A13))+1)),0)-IF(ISERROR(FIND("#",A13)),0,FIND("#",A13))-1)))
      第三题：=IF(IF(TEXT(ROUND(A23,1),"[dbnum2]")=SUBSTITUTE(TEXT(ROUND(A23,1),"[dbnum2]"),".","元"),SUBSTITUTE(TEXT(ROUND(A23,1),"[dbnum2]"),".","元")&"元整",SUBSTITUTE(TEXT(ROUND(A23,1),"[dbnum2]"),".","元")&"角")="零元整","零元整",IF(LEFT(IF(TEXT(ROUND(A23,1),"[dbnum2]")=SUBSTITUTE(TEXT(ROUND(A23,1),"[dbnum2]"),".","元"),SUBSTITUTE(TEXT(ROUND(A23,1),"[dbnum2]"),".","元")&"元整",SUBSTITUTE(TEXT(ROUND(A23,1),"[dbnum2]"),".","元")&"角"),2)="零元",SUBSTITUTE(IF(TEXT(ROUND(A23,1),"[dbnum2]")=SUBSTITUTE(TEXT(ROUND(A23,1),"[dbnum2]"),".","元"),SUBSTITUTE(TEXT(ROUND(A23,1),"[dbnum2]"),".","元")&"元整",SUBSTITUTE(TEXT(ROUND(A23,1),"[dbnum2]"),".","元")&"角"),"零元",),IF(TEXT(ROUND(A23,1),"[dbnum2]")=SUBSTITUTE(TEXT(ROUND(A23,1),"[dbnum2]"),".","元"),SUBSTITUTE(TEXT(ROUND(A23,1),"[dbnum2]"),".","元")&"元整",SUBSTITUTE(TEXT(ROUND(A23,1),"[dbnum2]"),".","元")&"角")))
      谢了

小痕

【函中201301班]-A16-小痕

练习1：解1=LEN(A3&A4&A5&A6&A7)-LEN(SUBSTITUTE(A3&A4&A5&A6&A7,"小妖",1))
             解2=SUM(LEN(A3:A7)-LEN(SUBSTITUTE(A3:A7,"小妖",1)))（数组）
练习2：=IFERROR(SUBSTITUTE(MID(A13,FIND("#",A13)+1,100),"#",""),"")
练习3：=IFERROR(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(TEXT(A23,"#.#")+0.001,"[DBNum2]"),".","元"),"零壹","角"),"零角","整"),"零元",""),"零元整")



谢谢批改！
         

ddmyykdzh

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

复制代码

1. 2、=IF(ISERROR(FIND("#",A13)),"",MID(A13,FIND("#",A13)+1,IF(ISERROR(FIND("*",SUBSTITUTE(A13,"#","*",2))-1),9,FIND("*",SUBSTITUTE(A13,"#","*",2))-1)-(FIND("#",A13))))

复制代码

第三题结果推出来了，但超过嵌套层次了，期待更好的解法！
【函中201301班]- A11-ddmyykdzh.zip (6.4 KB, 下载次数: 0)

2013-5-3 11:41 上传

点击文件名下载附件

fcyxiaoyuer

题目1

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

复制代码

数组公式

题目2

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

复制代码

题目3

1. =SUBSTITUTE((SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LEFT(x,LEN(x)-1)&"角","零角","整"),".","元"),"零元整",1),"零元",)),"1","零元整")

复制代码

令 X==TEXT(ROUND('1'!$A23,1)+0.01,"[dbnum2]")

【函中201301班]- A17-fcyxiaoyuer

zxh_273

【函中201301班】-A07-zxh_273
第1题：

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

复制代码

第2题：

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

复制代码

第3题：

1. =IF(ROUND(A23,1)=0,NUMBERSTRING(ROUND(A23,1),2)&"元整",IF(ROUND(A23,1)<1,NUMBERSTRING(INT((ROUND(A23,1)-INT(ROUND(A23,1))+0.001)*10),2)&"角",NUMBERSTRING(INT(ROUND(A23,1)),2)&"元"&IF(INT(ROUND(A23,1))=ROUND(A23,1),"整",NUMBERSTRING(INT((ROUND(A23,1)-INT(ROUND(A23,1))+0.001)*10),2)&"角")))

复制代码

清风细雨123

【函中201301班]- A02-清风细雨123
练习1：‘=SUM(LEN(A3:A7)-LEN(SUBSTITUTE(A3:A7,"小妖",0)))    ctrl+shift+enter结束
练习2：‘=LEFT(IF(IFERROR(FIND("#",A13),"")<>"",MID(A13,IFERROR(FIND("#",A13),"")+1,99),"")&"#",FIND("#",IF(IFERROR(FIND("#",A13),"")<>"",MID(A13,IFERROR(FIND("#",A13),"")+1,99),"")&"#")-1)

pxxrcw

第一个：=(LEN(PHONETIC(A3:A7))-LEN(SUBSTITUTE(PHONETIC(A3:A7),"小妖",)))/2
第二个：=REPLACE(REPLACE(A13,FIND("*",SUBSTITUTE(A13,"#","*",2)&"*"),10,),1,FIND("#",A13&"#"),)
第三个：=IF(A23=0,"零",IF(INT(ROUND(A23,1))=ROUND(A23,1),TEXT(ROUND(A23,1),"[DBNum2]")&"元整",IF(ROUND(A23,1)<1,SUBSTITUTE(TEXT(ROUND(A23,1),"[DBNum2]"),"零.",)&"角",SUBSTITUTE(TEXT(ROUND(A23,1),"[DBNum2]"),".","元")&"角")))