【函中201301班】- B20-ykfexcel
1,'=IF(FIND("0",B94&"0")=1,"零"&SUBSTITUTE(NUMBERSTRING(B94,3),TEXT(0,"[DBnum1]G/通用格式"),"零"),SUBSTITUTE(NUMBERSTRING(B94,3),TEXT(0,"[DBnum1]G/通用格式"),"零"))
2, 第二题公式太长,因此要分为两段,再用&连接,具体看附件
3,'=NUMBERSTRING(ROUND(C107,0),3)
4,=MATCH(C115,TEXT(ROW($1:$2000),"[<20][DBnum1][$-411]G/通用格式;[DBnum1][$-404]G/通用格式"),)三键
5,'=LEFT(B124,LEN(B124)*2-LENB(B124))
6,'=MID(B131,FIND("市",B131)+1,(SEARCHB("?",B131)-FINDB("市",B131))/2-1)
9讲作业.rar
(43.35 KB, 下载次数: 2)
|