[函初201203班]-A25-jinglingshu 作业一 答:=IF((C12)<60,"否",IF((D12)<60,"否",IF((E12)<60,"否","是"))) 作业二 答:=IF(C28="男",60-D28,IF(C28="女",55-D28)) =IF(E28>0,E28,) 作业三 答:=IF(F43<20,"庚",IF(F43<40,"己",IF(F43<60,"戊",IF(F43<70,"丁",IF(F43<80,"丙",IF(F43<90,"乙",IF(F43<100,"甲"))))))) 作业四 答案1(不用辅助列,公式很长,但不会再简化了) =SUM(IF(MOD(A58,2),B58*C58,0)+IF(MOD(A59,2),B59*C59,0)+IF(MOD(A60,2),B60*C60,0)+IF(MOD(A61,2),B61*C61,0)+IF(MOD(A62,2),B62*C62,0)+IF(MOD(A63,2),B63*C63,0)+IF(MOD(A64,2),B64*C64,0)+IF(MOD(A65,2),B65*C65,0)+IF(MOD(A66,2),B66*C66,0)+IF(MOD(A67,2),B67*C67,0) +IF(MOD(A68,2),B68*C68,0) +IF(MOD(A69,2),B69*C69,0)) 答案2(用辅助列,公式比较简练,可不会合二为一。) =IF(MOD(A58,2),B58*C58,0) =SUM(D58:D69) |