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

stone1969

stone1969 发表于 2013-5-1 20:52
【函中201301班]- B16：stone1969(1109590007)
第一题
=(LEN(A3)-LEN(SUBSTITUTE(A3,"小妖",0)))+(LEN(A ...

第一题方法1  =LEN(PHONETIC(A3:B7))-LEN(SUBSTITUTE(PHONETIC(A3:B7),"小妖",0))
          方法2 =LEN(A3&A4&A5&A6&A7&B3)-LEN(SUBSTITUTE((A3&A4&A5&A6&A7&B3),"小妖","1"))
第二题方法1  =TRIM(MID(SUBSTITUTE(A13,"#",REPT(" ",9)),9,9))

方法2=MID(MID(SUBSTITUTE(MID(SUBSTITUTE(A13,"#","#")&"#"&"#",FIND("#",SUBSTITUTE(A13,"#","#")&"#"&"#")+1,99),"#",REPT(" ",9)),1,9),1,9)
第三题=TEXT(INT(ROUND(A23,1)),"[DBNum2]G/通用格式元;;")&TEXT(ROUND(A23,1),";;零元")&TEXT(MOD(ROUND(A23,1),1)*10,"[DBNum2]0角;;整")

tayisha

第一题目答案：=LEN(A3)-LEN(SUBSTITUTE(A3,"小妖","#"))+LEN(A4)-LEN(SUBSTITUTE(A4,"小妖","#"))+LEN(A5)-LEN(SUBSTITUTE(A5,"小妖","#"))+LEN(A6)-LEN(SUBSTITUTE(A6,"小妖","#"))+LEN(A7)-LEN(SUBSTITUTE(A7,"小妖","#"))
第二题目答案：=IF(LENB(ASC(A13))-LENB(SUBSTITUTE(ASC(A13),"#",""))<1,"",IF(LENB(ASC(A13))-LENB(SUBSTITUTE(ASC(A13),"#",""))<2,MIDB(ASC(A13),FIND("#",ASC(A13),1)+1,100),SUBSTITUTE(MIDB(A13,FINDB("#",A13),(FINDB("#",A13,FINDB("#",A13)+1)-FINDB("#",A13))),"#","")))