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

风过无声

[函初201203班]- D02:风过无声
第一题

1. =IF(OR(C12="",D12="",E12=""),"否",IF(AND(C12>=60,D12>=60,E12>=60),"是","否"))
   
2. 第二题
   
3. [code]=IF(IF(C28="男",60-D28,50-D28)>=0,IF(C28="男",60-D28,50-D28),0)

复制代码

第三题

第四题

1. =IF(MOD(A$58:A$69,2)=1,B$58:B$69*C$58:C$69,0)

复制代码

1. =SUM(D58:D69)

复制代码

xcnclwh

1. =IF(C12<60,"否",IF(D12<60,"否",IF(E12<60,"否","是")))
   
2. =IF(AND(C12>=60,D12>=60,E12>=60),"是","否")
   
3. =IF(C28="男",IF(D28>=60,0,60-D28))+IF(C28="女",IF(D28>=55,0,55-D28))
   
4. =IF(AND(C28="男",D28<60),60-D28,IF(AND(C28="女",D28<55),55-D28,0))
   
5. =IF(F43<$B$43,$C$43,IF(F43<$B$44,$C$44,IF(F43<$B$45,$C$45,IF(F43<$B$46,$C$46,IF(F43<$B$47,$C$47,IF(F43<$B$48,$C$48,$C$49))))))
   
6. =MOD(A58,2)*B58*C58
   
7. =SUM(IF(MOD(A58:A69,2),B58:B69*C58:C69))
   

复制代码

xsl343866865

【函数初级201203班】-D24:xsl343866865
作业一：

1. =IF(AND(C12>60,D12>60,E12>60),"是","否")
   

复制代码

作业二：

1. =IF(AND(C28="男",D28<60),60-D28,IF(AND(C28="女",D28<55),55-D28,0))
   
2. =IF(C28="男",MAX(60-D28,0),MAX(55-D28,0))

复制代码

作业三：

1. =LOOKUP(F43,$A$43:$A$49,$C$43:$C$49)
   
2. =VLOOKUP(F43,CHOOSE({1,2},$A$43:$A$49,$C$43:$C$49),2,1)
   
3. =VLOOKUP(F43,IF({1,0},$A$43:$A$49,$C$43:$C$49),2,1)
   
4. =INDEX($C$43:$C$49,MATCH(F43,$A$43:$A$49,1))
   
5. =INDIRECT("C"&ROW(A$42)+MATCH(F43,$A$43:$A$49,1),1)

复制代码

作业四：

1. =SUMPRODUCT(MOD(A58:A69,2)*(B58:B69)*(C58:C69))
   
2. {=SUM(MOD(A58:A69,2)*B58:B69*C58:C69)}
   
3. =SUMPRODUCT(ISODD(INDIRECT("A"&ROW($58:$69),1))*(B58:B69)*(C58:C69))
   
4. {=SUM((ISODD(INDIRECT("A"&ROW($58:$69),1)))*B58:B69*C58:C69)}

复制代码

xiaox0124

1. =IF(OR(C12<60,D12<60,E12<60),"否","是")

复制代码

1. =IF(C28="男",IF(D28<60,60-D28,0),IF(D28<55,55-D28,0))

复制代码

1. =LOOKUP(F43,$A$43:$A$49,$C$43:$C$49)

复制代码

1. =SUMPRODUCT(MOD(A58:A69,2),B58:B69,C58:C69)
   

复制代码

【函初201203班】D05-xiaox0124

tbcdmp

【函初201203班]- D13:tbcdmp
第一题：=IF(C12<60,"否",IF(D12<60,"否",IF(E12<60,"否","是")))
第二题：=IF(IF(C28="男",60-D28,55-D28)>0,IF(C28="男",60-D28,55-D28),0)
第三题：=VLOOKUP(F43,$A$43:$C$49,3,TRUE)
第四题：=SUMPRODUCT(MOD((A58:A69),2)*B58:B69,C58:C69)

没听到课，烦请更改，谢谢

xzsychenwei01

【函初201203班】- D17:xzsychenwei01
作业一：

1. F12=IF(AND(C12>60,D12>60,E12>60),"是","否")

复制代码

作业二：

1. E28=IF(AND(C28="男",D28<60),60-D28,IF(AND(C28="女",D28<55),55-D28,0))

复制代码

作业三：

1. G43=VLOOKUP(F43,$A$43:$C$49,3)

复制代码

作业四：
1、

1. D58=IF(ISODD(A58),B58*C58,0)，向下填充至D69

复制代码

1. D70=SUM(D58:D69)

复制代码

2、

1. D70=SUMPRODUCT((MOD(A58:A69,2)=1)*B58:B69*C58:C69)

复制代码

dilunn

【函初201203班]- D29:dilunn
作业已上交，谢谢老师！！

zjy12366

201203   D15 zjy12366
1  =IF(SUM(COUNT(C12:E12)*1=3),"是","否")
2  =LOOKUP(F43,$A$43:$A$49,$C$43:$C$49)

zjy12366

201203   D15 zjy12366
我的第2题的答案其实是第3题的

lion_zjy

【函初201203班]- D14-Lion_zjy
第一题：=IF(AND(C12>=60,D12>=60,E12>=60),"是","否")
第二题：=IF(IF(C28="男",60-D28,55-D28)<0,0,IF(C28="男",60-D28,55-D28))
第三题：=LOOKUP(F43,$A$43:$A$49,$C$43:$C$49)
第四题：=SUM((MOD(A58:A69,2)=1)*B58:B69*C58:C69)