【函中20130301】第十讲B组作业上交帖

风花雪月8888

1、=SUM(--TEXT({1;"A";2;10;15.76;"B";21},"[<10]!0;[>20]!0;0%;!0"))
2、=SUBSTITUTE(TEXT(C157,"#"&REPT("!,00",INT(LEN(C157)/2.1))),",0",",")
3、=PRODUCT(--TEXT(MID(SUBSTITUTE(C164,"*",REPT(" ",9)),{1,9},9),"0.00;;;!1"))
4、=TEXT(C173,"[DBNum1]0")
5、=MID(C181,FIND("/",C181)-9,3)
    =TEXT(MID(C181,FIND("/",C181)-2,2)&"/1","mmm")

【函中201301班】-B07-风花雪月8888