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

nuf2002

题一解：
    f12中输入 =IF((C12="")+(D12="")+(E12=""),"否",IF((C12>=60)*(D12>=60)*(E12>=60),"是","否"))，下拉；

题二解：
   E28中输入 =IF(C28="男",IF(D28>=60,0,60-D28),IF(D28>=55,0,55-D28))，下拉；

题三解：
   G43中输入 =IF(F43<20,"庚",IF(F43<40,"己",IF(F43<60,"戊",IF(F43<70,"丁",IF(F43<80,"丙",IF(F43<90,"乙","甲"))))))，下拉；

题四解：
   D58中输入 =IF(MOD(A58,2)<>0,PRODUCT(B58,C58),"")，下拉得辅助数列，再在D70中输入 =SUM(D58:D69)完成计算。

用最笨的办法总算到了相同结果，别的方法还没想出来，先交作业吧，辛苦学委哦，谢谢！

【函初201203班】-C05-nuf2002

xcslp

【函初201203班]- c37-id:xcslp
1.=IF(AND(C12>60,D12>60,E12>60),"是","否")
2.=IF(AND(C28="男",D28<=60),60-D28,0)
=IF(AND(C28="女",D28<=55),55-D28,0)
3.=VLOOKUP(F43,$A$42:$C$49,3,1)
4.=B58*C58先拉复制公式
=SUMPRODUCT((MOD(ROW(D58:D69),2)=0)*D58:D69)

xcslp

【函初201203班]- c37-xcslp;
1.IF(AND(C12>60,D12>60,E12>60),"是","否")
2.=IF(C28="女",IF(D28>55,0,55-D28),IF(D28>60,0,60-D28))
3.=VLOOKUP(F43,$A$42:$C$49,3,1)
4.=B58*C58 向下复制公式
5.=SUMPRODUCT((MOD(ROW(D58:D69),2)=0)*D58:D69)

frank-du

【函初201203班】C02-frank-du
作业一：F12输入=IF(OR(C12<60,D12<60,E12<60),"否","是")，然后下拉
作业二：E28输入=IF(C28="男",IF(D28<60,60-D28,0),IF(D28<55,55-D28,0))，然后下拉
作业三：G43输入=LOOKUP(F43,A$43:A$49,C$43:C$49)，然后下拉
作业四：D58输入=IF(ISODD(A58),B58*C58,0)，然后下拉；最后在D70输入=SUM(D58:D69)

fxh1220

【函初201203班]- C16-FXH1220
1.IF(C12<60,"否",IF(D12<60,"否",IF(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，用了辅助列，IF(MOD(A58,2)=1,B58*C58,"")，下拉，结果求和

9201225

【函初201203班】-C12-9201225.rar (111.92 KB, 下载次数: 1)

2012-12-18 17:09 上传

点击文件名下载附件

1. 
   
2. <BLOCKQUOTE>=IF(AND(C12>60,D12>60,E12>60),"是","否")
   
3. =IF(COUNTIF(C12:E12,">60")>2,"是","否")
   

复制代码

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

复制代码

1. =IF(F43<20,C$43,IF(F43<40,C$44,IF(F43<60,C$45,IF(F43<70,C$46,IF(F43<80,C$47,IF(F43<90,C$48,C$49))))))

复制代码

1. =IF(MOD(A58,2),B58*C58,)
   
2. =SUM(D58:D69)
   
3. 
   
4. =SUMPRODUCT((MOD(A58:A69,2)=1)*(B58:B69)*(C58:C69))

复制代码

lfwzh0059

【函初201203班]- c11-lfwzh0059
作业1=IF(C12>60,IF(D12>60,IF(E12>60,"是","否"),"否"),"否")
作业2=IF(C28="男",IF(60-D28<0,"0",60-D28),IF(55-D28<0,"0",55-D28))
作业3=VLOOKUP(F43,$A$43:$C$49,3)
作业4使用辅助列=IF(MOD(A58,2),B58*C58,) 然后下拉，d70单元格=SUM(D58:D69)
或者也使用辅助列b58*c58，下拉, d70单元格=SUMPRODUCT(SUMIF(A58:A69,{1,3,5,7,9,11},D58:D69))

liaoxingchao

---

【函初201203班】-C25-liaoxingchao;
第一题：=IF(AND(E12>=60,C12>=60,D12>=60),"是","否")
第二题：=IF(C28="男",TEXT(60-D28,"0;!0;;"),TEXT(55-D28,"0;!0;;"))
第三题：=VLOOKUP(F43,$A$43:$C$49,3)
第四题：=IF(ISEVEN(A58),0,B58*C58)

---

pang1688

【函初201203班】-c30-pang1688
第二讲作业：
1、=IF(AND(C12>=60,D12>=60,E12>=60),"是","否")；
2、=IF(IF(C28="男",60-D28,55-D28)>0,IF(C28="男",60-D28,55-D28),0)；
3、=IF(F43<20,"庚",IF(F43<40,"已",IF(F43<60,"戊",IF(F43<70,"丁",IF(F43<80,"丙",IF(F43<90,"乙","甲"))))))；
4、{=SUM(IF(MOD(A58:A69,2),B58:B69,0)*C58:C69)}

w1098

【函初201203班]- c29-w1098
1.=TEXT(COUNTIF(C12:E12,">="&60),"[=3]是;否")
2.=TEXT(60-D28-(C28="女")*5,"0;!0;0")
3.=LOOKUP(F43,A$43:A$49,C$43:C$49)
4.=-SUMPRODUCT(-(LEN(A58:A69/2)=3),B58:B69,C58:C69)