【函中201301班第十讲作业】-C10-雨后的风
第一题:- =SUM(--TEXT({1;"A";2;10;15.76;"B";21},"[>20]!0;[<10]!0;0.00;!0"))
复制代码 第二题:- =SUBSTITUTE(REPLACE(TEXT(C157,REPT("!,##",(LEN(C157)+1)/2)),1,1,),",0",",")
复制代码- =MID(SUBSTITUTE(TEXT(C157,REPT("!,00",ROUND(LEN(C157)/2,))),",0",","),2,99)
复制代码 第三题:- =PRODUCT(--TEXT(MID(SUBSTITUTE(C164,"*",REPT(" ",15)),{1,16},15),"G/通用格式;;;!1"),{1;1})
复制代码- =PRODUCT({1;1},IFERROR(--MID(SUBSTITUTE(C164,"*",REPT(" ",15)),{1,16},15),1))
复制代码- =TEXT(MID(C164,FIND("*",C164&"*")+1,15),"G/通用格式;;;!1")*LEFT(C164,FIND("*",C164&"*")-1)
复制代码 第四题:- =TEXT(DATE(C173,2,),"[dbnum1]e")
复制代码- =TEXT(C173&"-1-1","[DBNUM1]e")
复制代码 第五题:- =MID(C181,SUM(IFERROR(FIND(TEXT("2013-"&ROW($1:$12)&"-1","mmm"),C181),)),3)
复制代码- =TEXT(DATE(2013,SUM(IF(ISNUMBER(FIND(TEXT("2013-"&ROW($1:$12)&"-1","mmm"),C181)),ROW($1:$12),)),1),"mmm")
复制代码 |