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

fupi

这礼拜乒乓球比赛还当裁判，作业交晚了，课也没听上，只能听视频了。
【2014函数初级班】-B015-fupi
1、判断性别
=IF(LEN(C7)>15,IF(MOD(MID(C7,17,1),2)=0,"女","男"),IF(MOD(RIGHT(C7,1),2)=0,"女","男"))
=IF(MOD(MID(C7,IF(LEN(C7)=15,15,17),1),2),"男","女")
=IF(MOD(RIGHT(LEFT(C7,17)),2),"男","女")
2、使用if函数
=IF(OR(C20=0,C20=5),0,IF(OR(C20=2,C20=7),2,IF(OR(C20=4,C20=9),4,C20)))
3、
{=SUM(--NOT((D35:D45="B")*(E35:E45="中专")))}
{=SUM(1-((D35:D45="B")*(E35:E45="中专")))}

小猪唛01

一、1 IF(LEN(C7)=15,IF(ISEVEN(RIGHT(C7)),"女","男"),IF(LEN(C7)=18,IF(ISEVEN(MID(C7,17,1)),"女","男"),"身份证号码位数不正确"))
      2 IF(LEN(C7)=18,IF(ISEVEN(MID(C7,17,1)),"女","男"),IF(LEN(C7)=15,IF(ISEVEN(MID(C7,15,1)),"女","男")))
      3 IF(OR(LEN(C7)=15,LEN(C7)=18),IF(MOD(MID(C7,15,3)*1,2),"男","女"))
二、IF(OR(C20=0,C20=5),0,IF(OR(C20=2,C20=7),2,IF(OR(C20=4,C20=9),4,C20)))
三、1 {SUM(--NOT((D35:D45="B")*(E35:E45="中专")))}
      2 {SUM((1-(D35:D45="B")*(E35:E45="中专")))}