本帖最后由 daichaodaichao 于 2013-7-3 22:11 编辑
【函中201301班】-A09-daichaodaichao- 1. =IF(LEN(SUBSTITUTE(NUMBERSTRING(B94,3),"○","零"))=7,SUBSTITUTE(NUMBERSTRING(B94,3),"○","零"),"零"&SUBSTITUTE(NUMBERSTRING(B94,3),"○","零"))
- 2.=TEXT(SUM((FIND(MID(B100,ROW($1:$7),1),"零一二三四五六七八九")-1)*10^(7-ROW($1:$7))),REPT(0,7))
- 3.=NUMBERSTRING(ROUND(C107,0),3)
- 4.=MATCH(C115,SUBSTITUTE(SUBSTITUTE(TEXT(ROW($1:$10000),"[DBNUM1]")),"○","零"),IF(LEN(C115)=2,"一十",""),IF(LEN(C115)=2,"十","")),0)
- 5.=LEFT(B124,2*LEN(B124)-LENB(B124))
- 6.=MID(B131,FIND("市",B131)+1,(ROUNDUP(SEARCHB("?",B131)/2,0)-FIND("市",B131)-1))
复制代码 |