本帖最后由 huanran2000 于 2012-12-16 21:59 编辑
【函初201203班】-A21-HUANRAN2000
作业一:=IF((C12>=60)*(D12>=60)*(E12>=60),"是","否")
=IF(AND(C12>=60,D12>=60,E12>=60),"是","否")
作业二:=IF(OR(IF(C28="男",D28>=60),IF(C28="女",D28>=55)),"0",IF(C28="男",60-D28,55-D28))
=IF(OR((C28="男")*(D28>=60),(C28="女")*(D28>=55)),0,IF(C28="男",60-D28,55-D28))
作业三:=VLOOKUP(F43,$A$43:$C$49,3,1)
=LOOKUP(F43,$A$43:$A$49,$C$43:$C$49)
=INDEX($C$43:$C$49,(MATCH(F43,$A$43:$A$49)))
=INDIRECT("C"&(42+MATCH(F43,$A$43:$A$49)))
=CHOOSE(MATCH(F43,$A$43:$A$49),$C$43,$C$44,$C$45,$C$46,$C$47,$C$48,$C$49)
作业四:方法一: =SUMPRODUCT(MOD(A58:A69,2)*B58:B69*C58:C69)
方法二:辅助列公式:=ISODD(A58)*B58*C58
求和公式 =SUM(D58:D69)
|