【函数初级201203班】第二讲C组作业上交帖[已开贴]

魔魔

开贴,有不明白或不对的地方,Q我,或群里找我

moyanzhiai

【函初201203班]- c33-moyanzhiai
作业1、=IF(AND(COUNT(C12:E12)=3,C12>=60,D12>=60,E12>=60),"是","否")
作业2、=IF(IF(C28="男",60-D28,55-D28)<0,0,IF(C28="男",60-D28,55-D28))
作业3、=LOOKUP(F43,$A$43:$A$49,$C$43:$C$49)
作业4、=SUMPRODUCT((MOD(A58:A69,2))*(B58:B69)*(C58:C69))

shandianzhiwu

【函初201203班]-C10-shandianzhiwu
作业二：
=IF(C28="男",IF(D28>=60,0,60-D28),IF(D28>=55,0,55-D28))
作业三：
=IF(F43>=90,"甲",IF(F43>=80,"乙",IF(F43>=70,"丙",IF(F43>=60,"丁",IF(F43>=40,"戊",IF(F43>=20,"己","庚"))))))

shandianzhiwu

【函初201203班]-C10-shandianzhiwu
作业一：
=IF(AND(C12>60,D12>60,E12>60),"是","否")
作业二：
=IF(C28="男",IF(D28>=60,0,60-D28),IF(D28>=55,0,55-D28))
作业三：
=IF(F43>=90,"甲",IF(F43>=80,"乙",IF(F43>=70,"丙",IF(F43>=60,"丁",IF(F43>=40,"戊",IF(F43>=20,"己","庚"))))))
作业四：=B58*C58
=SUM(IF(MOD(({1;2;3;4;5;6;7;8;9;10;11;12}),2)=1,D58:D69,))