|
作业一:
=SUM(--MID(C11,ROW(INDIRECT("1:"&LEN(C11))),1))
作业二:
=LEFT(C16,SEARCHB("?",C16)/2)
=RIGHTB(C17,MATCH(" ",MIDB(C17,ROW(INDIRECT("1:"&LENB(C17))),1),0)/2+1)
作业三:
法一:=DAY(EOMONTH(A22,0))
法二:=EOMONTH(A22,0)-EOMONTH(A22,-1)
法三:=IF(AND(OR(YEAR(A22)/400=TRUNC(YEAR(A22)/400),YEAR(A22)/4=TRUNC(YEAR(A22)/4)),MONTH(A22)=2),29,IF(OR(MONTH(A22)=1,MONTH(A22)=3,MONTH(A22)=5,MONTH(A22)=7,MONTH(A22)=8,MONTH(A22)=10,MONTH(A22)=12),31,IF(OR(MONTH(A22)=4,MONTH(A22)=6,MONTH(A22)=9,MONTH(A22)=11),30,28)))
作业四:
法一:=SUMPRODUCT((MONTH($A$33:$A$62)=12)*(CODE($B$33:$B$62)=CODE($A$27))*($C$33:$C$62))
法二:=SUM((MONTH($A$33:$A$62)=12)*(CODE($B$33:$B$62)=CODE($A$27))*($C$33:$C$62))
法三:=SUM((MONTH($A$33:$A$62)=12)*(EXACT($B$33:$B$62,$A$27)=TRUE)*($C$33:$C$62))
作业五:
计算星期:=TEXT(WEEKDAY(A33,2),"星期[DBNUM1]#")
计算本月(12月)对应星期的销售额:=SUMPRODUCT((MONTH($A$33:$A$62)=12)*($D$33:$D$62=G33)*($C$33:$C$62))
【函初201203班】-D08-MYHERE131
注:完成作业时已经是1月份了,故题目中提到的本月(只有11和12月)无法用函数来自动计算本月,故用12替代。 |
评分
-
查看全部评分
|