本帖最后由 新华人家 于 2013-1-2 21:33 编辑
[函初201203班]- A06-新华人家
作业一:- {=SUM(--MID(C11,CHOOSE(LEN(C11),{1},{1,2},{1,2,3},{1,2,3,4},{1,2,3,4,5},{1,2,3,4,5,6}),1))}
复制代码- {=SUM(IF(ISERROR(--(MID(C11,ROW(INDIRECT("1:"&LEN(C11))),1))),0,--(MID(C11,ROW(INDIRECT("1:"&LEN(C11))),1))))}
复制代码 作业二:- =LEFT(C16,LENB(C16)-LEN(C16))
复制代码- =RIGHT(C17,LENB(C17)-LEN(C17))
复制代码 作业三:- =DAY(DATE(YEAR(A22),MONTH(A22)+1,0))
复制代码- =CHOOSE(MONTH(A22),31,IF(MOD(YEAR(A22),4)=0,29,28),31,30,31,30,31,31,30,31,30,31)
复制代码 作业四:- =SUMPRODUCT(--EXACT(B33:B62,A27),C33:C62)
复制代码- {=SUM((CODE(A27)=CODE(B33:B62))*C33:C62)}
复制代码- {=SUM(NOT(ISERROR((FIND(A27,B33:B62))))*(C33:C62))}
复制代码 作业五:- =SUMPRODUCT((WEEKDAY($A$33:$A$62,2)=F33)*($C$33:$C$62))
复制代码 |