本帖最后由 Joyce_chen 于 2012-12-16 08:23 编辑
【函初201203班】-C21-Joyce_chen
作业1:在F12输入:=IF(AND(C12>=60,D12>=60,E12>=60),"是","否") 下拉完成!
作业2:在E28输入:=IF(IF(C28="男",60-D28,IF(C28="女",55-D28))<0,"0",IF(C28="男",60-D28,IF(C28="女",55-D28)))下拉完成!
作业3:在G43输入:1、=IF(F43>=$A$49,$C$49,IF(F43>=$A$48,$C$48,IF(F43>=$A$47,$C$47,IF(F43>=$A$46,$C$46,IF(F43>=$A$45,$C$45,IF(F43>=$A$44,$C$44,$C$43))))))下拉完成!
2、=IF(F43<20,"庚",IF(F43<40,"己",IF(F43<60,"戊",IF(F43<70,"丁",IF(F43<80,"丙",IF(F43<90,"乙","甲"))))))
作业4:1、在D70处输入{=SUM((MOD(A58:A69,2)=1)*B58:B69*C58:C69)}完成!
2、03版解法:在D58输入C58*B58下拉,然后在D70 输入=SUM(SUMIF(A57:A69,{"1","3","5","7","9","11"},D57:D69))
3、07版解法:在D58输入=IF(ISODD(A58),C58*B58)下拉,然后在D70 输入=SUM(D58:D69)
|