|
本帖最后由 一杯清荼 于 2013-1-3 00:44 编辑
【函初201203班】-C08-一杯清荼
作业1:- =SUM(--(MID(C11,ROW(INDIRECT("1:"&LEN(C11))),1)))
复制代码- =SUM(--(0&MID(C11,ROW(A:A),1)))
复制代码 作业2:- =LEFT(C16,2)
- =RIGHT(C17,2)
复制代码- =MID(C16,MATCH(2,LENB(MID(C16,ROW(INDIRECT("1:"&LEN(C16))),1)),),2)
复制代码- =MID(C16,MATCH(TRUE,MID(C16,ROW(INDIRECT("1:"&LEN(C16))),1)>="吖",),2)
复制代码- =MID(C16,MATCH(TRUE,RIGHT(LEFT(C16,ROW(A:A)))>="吖",),LENB(C16)-LEN(C16))
复制代码 作业3:- =DAY(DATE(YEAR(A22),MONTH(A22)+1,0))
复制代码- =DATEDIF(EOMONTH(A22,-1),EOMONTH(A22,0),"d")
复制代码- =DATEDIF(A22,EOMONTH(A22,0),"d")+DAY(A22)
复制代码 作业4:- =SUM(EXACT(A27,B33:B62)*C33:C62)
复制代码- =SUM((A27<>"")*(FIND(A27,B33:B62&A27)=1)*C33:C62)
复制代码- =SUM(IF((A27<>""),(CODE(A27)=CODE(B33:B62))*C33:C62))
复制代码 作业5:- =SUM((WEEKDAY($A$33:$A$62,2)=ROW(A1))*$C$33:$C$62)
复制代码 |
评分
-
查看全部评分
|