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

ghostjiao

ghostjiao

第一题：

1. =IF(ISODD(MID(C7,15,3)),"男","女")

复制代码

1. =IF(ISEVEN(RIGHT(LEFT(C7,17))),"女","男")

复制代码

1. =TEXT(-1^MID(C7,9,9),"女;男")

复制代码

第二题：

1. =IF(OR(C20={5,0}),0,IF(OR(C20={2;7}),2,IF(OR(C20={4;9}),4,C20)))               三键

复制代码

1. =--MID("0123406284",C20+1,1)

复制代码

第三题

1. =SUM(NOT((D35:D45="B")*(E35:E45="中专"))/1)           三键

复制代码

1. =SUM(ROUNDUP(((D35:D45<>"B")+(E35:E45<>"中专"))/2,))   三键

复制代码

air05

学委辛苦了
C015-air05作业答案
一.解法1.=IF(LEN(C7)=18,IF(ISEVEN(MID(C7,17,1)),"女","男"),IF(ISEVEN(RIGHT(C7,1)),"女","男"))
    解法2.=IF(ISEVEN(MID(C7,15+(LEN(C7)=18)*2,1)),"女","男")
    解法3.=IF(ISEVEN(MID(C7,15,3)),"女","男")
二.解法1. =IF(C20<=4,C20,IF((MOD(C20,2)=0),C20,C20-5))
     解法2. =IF(OR(C20=0,C20=5),0,IF(OR(C20=2,C20=7),2,IF(OR(C20=4,C20=9),4,C20)))
三. 解法1. =SUMPRODUCT(--NOT((D35:D45="B")*(E35:E45="中专")))
      解法2. =SUMPRODUCT(1-((D35:D45="B")*(E35:E45="中专")))

suaimin568568

一.
1.=IF(MOD(MID(C7,15,3),2),"男","女")
2.=IF(ISEVEN(MID(C7,15,3)),"女","男")
3.=IF(MOD(IF(LEN(C7)=15,MID(C7,15,1),MID(C7,17,1)),2)=1,"男","女")
二.=IF(OR(C20=5,C20=0),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="中专"))))三键

coreluo

∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽∽班长记号

xwp2010

[201401函初班] c001-xwp2010
1
E7=IF(LEN(C7)=18,IF(ISODD(MID(C7,17,1)),"男","女"),IF(ISODD(RIGHT(C7)),"男","女"))
F7=IF(LEN(C7)=18,IF(ISEVEN(MID(C7,17,1)),"女","男"),IF(ISEVEN(RIGHT(C7)),"女","男"))
G7=IF(LEN(C7)=15,IF(MOD(RIGHT(C7),2),"男","女"),IF(MOD(MID(C7,17,1),2),"男","女"))
2
D20=IF(OR(C20=0,C20=5),0,IF(OR(C20=2,C20=7),2,IF(OR(C20=4,C20=9),4,C20)))
3
G35=SUMPRODUCT(--NOT((D35:D45="B")*(E35:E45="中专")))
H35=COUNTIF(D35:D45,"*")-COUNTIFS(D35:D45,"B",E35:E45,"中专")

yiyijiayou2015

第一题：1种方法=IF(LEN(C7)=18,IF(MOD(MID(C7,15,3),2),"男","女"),IF(MOD(MID(C7,13,3),2),"男","女"))
            2种方法：=IF(MOD(RIGHT(LEFT(C7,17),3),2),"男","女")
            3种方法：IF(MOD(RIGHT(LEFT(C7,17)),2),"男","女")
第二题：IF(OR(C20=0,C20=5),0,IF(OR(C20=2,C20=7),2,IF(OR(C20=4,C20=9),4,C20)))
第三题：=COUNTA($C$35:$C$45)-COUNTIFS($D$35:$D$45,"B",$E$35:$E$45,"中专")
=COUNTA($C$35:$C$45)-SUM(NOT($D$35:$D$45<>"B")*NOT($E$35:$E$45<>"中专"))

happylife_2005

交作业喽

hhxy

2014函初－C012-HHXY

一：=IF(MOD(MID(C7,15,3),2),"男","女")
      =IF(ISEVEN(MID(C7,15,3)),"女","男")
      =TEXT(MOD(MID(C7,15,3),2), "男;;女")

二：=IF(OR(C20:C29=0,C20:C29=5),0,IF(OR(C20:C29=2,C20:C29=7),2,IF(OR(C20:C29=4,C20:C29=9),4,C20:C29)))

三：=ROW(A11)-SUM((D35:D45="B")*(E35:E45="中专"))  三键
    =SUM(--NOT((D35:D45="B")*(E35:E45="中专")))       三键

潇潇雨歇20088

1. 一、
   
2. =IF(ISEVEN(LEFT(C7,17)),"女","男")
   
3. =IF(ISEVEN(MID(C7,15,3)),"女","男")
   
4. =IF(MOD(MID(C7,15,3),2)=0,"女","男")
   
5. =IF(ISODD(LEFT(C7,17)),"男","女")
   
6. 
   
7. 二、
   
8. =IF(OR(C20=0,C20=5),0,IF(OR(C20=2,C20=7),2,IF(OR(C20=4,C20=9),4,C20)))
   
9. 
   
10. 三、
    
11. =SUM(--NOT((D35:D45="B")*(E35:E45="中专")))   （三键）
    
12. =SUM(1-((D35:D45="B")*(E35:E45="中专")))   （三键）
    
13. =SUMPRODUCT(1-((D35:D45="B")*(E35:E45="中专")))
    

复制代码

【函数初级班】-C021-潇潇雨歇20088，第三讲作业，请老师审阅。

xuyouxm

1. =11-SUM((D:D&E:E=D36&E36)*1)

复制代码

最后一题来个修改后的。

点评的字符数一样的，差不多。