【函初201203班]- A09-水上漂123
第一题- 答案1:=SUM(IF(ISNUMBER(--MID($C$11,ROW(1:99),1)),MID($C$11,ROW(1:99),1)*1))数组
- 答案1:=SUM(--MID($C$11,ROW(INDIRECT("1:"&LEN($C$11))),1))数组
复制代码 第二题- 答案1:=MID(C16,MIN(IF(CODE(MID(C16,ROW(INDIRECT("a1:a"&LEN(C16))),1))>1000,ROW(INDIRECT("a1:a"&LEN(C16))))),(LENB(C16)-LEN(C16)))数组
- 答案2:=MID(C16,MATCH(1=1,MID(C16,ROW($1:$20),1)>="啊",),(LENB(C16)-LEN(C16)))数组
- 答案3:=MID(C16,MATCH(2,LENB(MID(C16,ROW($1:$10),1)),0),LENB(C16)-LEN(C16))数组
- 答案4:不通用=LEFT(C16,2);=RIGHT(C17,2)
复制代码 第三题- 答案1:=DAY(EOMONTH(A22,0))
- 答案2:=DAY(DATE(YEAR(A22),MONTH(A22)+1,0))
- 答案3:=DAY(EDATE(A22,1)-DAY(A22))
- 答案4:=EOMONTH(A22,0)-EOMONTH(A22,-1)
复制代码 第四题- 答案1:=SUMPRODUCT(ISNUMBER(FIND(A27,B33:B62))*(MONTH(A33:A62)=12)*(C33:C62))
- 答案2:=SUMPRODUCT(EXACT(A27,B33:B62)*(MONTH(A33:A62)=12)*(C33:C62))
- 答案3:SUMPRODUCT((CODE(B33:B62)=99)*(C33:C62)*(MONTH(A33:A62)=12))
复制代码 第五题- 星期:=TEXT(WEEKDAY(A33,1),"[$-804]aaaa;@")
- 总销售额:=SUMPRODUCT(($D$33:$D$62=G33)*($C$33:$C$62))
复制代码 |