本帖最后由 笨笨四 于 2013-12-2 09:08 编辑
练习题,只需注明题号、答案即可。
非2013新手班同学回贴作答扣经验、扣BB。谢谢支持。
开贴
参考答案:
基础题:法1:IF(OR(B2:D2<60),"否","是")
法2:IF(MIN(B2:D2)>=60,"是","否")
一题:法1:MID("EEEEEEDCBAA",1+B2/10,1)
法2:IF(B2<60,"E",IF(B2<70,"D",IF(B2<80,"C",IF(B2<90,"B","A"))))
二题:法1:IF(COUNTIF(B$2:B2,B2)=1,SUMIF(B:B,B2,C:C),"")
法2:IF(MATCH(B2,$B$1:$B$12,)=ROW(),SUMIF(B:B,B2,C:C),"")
三题:法1:MAX(IF(MONTH(A2:A11)<4,B2:B11))数组
法2:MAX((MONTH(A2:A11)<4)*B2:B11)数组
四题:法1:IF(COUNT(FIND(ROW($1:$10)-1,A2)),"有数字","无数字")数组
法2:IF(COUNT(MID(A2,ROW($1:99),1)*1),"有数字","无数字")数组
法3:IF(OR(ISNUMBER(-MID(A2,ROW($1:$20),1))),"有数字","无数字")
五题:法1:RIGHT(VLOOKUP(G$1,A:D,ROW(),),IF(ROW()>3,3,9))
法3:IF(ROW()>3,RIGHT(VLOOKUP(G$1,A$1:D$9,ROW(),),3),VLOOKUP(G$1,A$1:D$9,ROW(),))
法2:RIGHT(VLOOKUP(G$1,A:D,ROW(),),9*(ROW()<4)+3) |