[201401函初班]第三讲作业D组上交贴【已开帖】

kinsey1225

D005-kinsey1225
1,=IF(MOD(MID(C7,15,3),2),"男","女")
   =IF(ISEVEN(MID(C7,15,3)),"女","男")
   =IF(ISODD(MID(C7,15,3)),"男","女")
2,=IF(OR(C20=0,C20=5),0,IF(OR(C20=2,C20=7),2,IF(OR(C20=4,C20=9),4,C20)))
3,=11-COUNTIFS(D35:D45,"B",E35:E45,"中专")
   =SUM(--NOT((D35:D45="B")*(E35:E45="中专")))   三键

汉娜

【2014函数初级班】-D024-汉娜
一，1=IF(MOD(IF(LEN(C7)=15,MID(C7,15,1),MID(C7,17,1)),2)=1,"男","女")
2=IF(LEN(C7)=15,IF(MOD(MID(C7,15,1),2)=1,"男","女"),IF(MOD(MID(C7,17,1),2)=1,"男","女"))
3=？
二，=IF(C20=5,0,(IF(C20=7,2,IF(C20=9,4,C20))))
三，1=COUNTA(C35:C45)-SUMPRODUCT((D35:D45="B")*(E35:E45="中专"))
2=？

a595885232

1，=IF(LEN(C7)=15,IF(MOD(RIGHT(C7,1),2)=0,"女","男"),IF(MOD(MID(C7,17,1),2)=0,"女","男"))
=TEXT(MOD(MID(C7,15,3),2),"男;;女")
2，=IF(OR(C20=0,C20=5),0,IF(OR(C20=2,C20=7),2,IF(OR(C20=4,C20=9),4,C20)))
3，=SUM(N(NOT(($D$35:$D$45="B")*($E$35:$E$45="中专"))))
=SUM(N(($D$35:$D$45="B")*($E$35:$E$45="中专")=0))

dxyan

交作业了

coreluo

班长统计作业记号.......................................