本帖最后由 yjeeee 于 2013-7-25 00:37 编辑
【函中201301班】- C07-yjeeee
第1题- =SUM(--TEXT(TEXT({1;"A";2;10;15.76;"B";21},"[>=10]0.00;!0;!0;!0"),"[<=20]0.00;!0;!0;!0"))
复制代码 第2题- =SUBSTITUTE(TEXT(C157,REPT("0!,0",INT((LEN(C157)-0.1)/2))&0),",0",",")
复制代码 第3题- =IF(TEXT(FIND("*",C164&"*"),"[>"&LEN(C164)&"]!0;0")="0",C164,PRODUCT(--SUBSTITUTE(MID(SUBSTITUTE(C164,"*",REPT("A",99)),{0,1}*99+1,99),"A","")))
复制代码- =IFERROR(MID(C164,1,TEXT(FIND("*",C164&"*"),"[>"&LEN(C164)&"]!0;0")-1)*MID(C164,TEXT(FIND("*",C164&"*"),"[>"&LEN(C164)&"]!0;0")+1,LEN(C164)-TEXT(FIND("*",C164&"*"),"[>"&LEN(C164)&"]!0;0")),C164)
复制代码 第4题- =TEXT(DATE(C173,1,1),"[DBNum1]yyyy")
复制代码 第5题
不会! |