函入5期第二讲作业上交专贴－－－（4组）

hxy_nt_ls

<p>函入5期4组050学员上交作业</p><p>

游客，如果您要查看本帖隐藏内容请回复

</p><p><strong><font color="#ff0000">OK</font></strong></p>

[此贴子已经被一剑惊心于2010-1-15 19:56:07编辑过]

cr123

游客，如果您要查看本帖隐藏内容请回复

</p><p><strong><font color="#ff0000">不错</font></strong></p>

[此贴子已经被一剑惊心于2010-1-18 19:42:35编辑过]

juju桔桔

054交作业

juju桔桔

<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;054交作业</p><p>第一题&nbsp;&nbsp;&nbsp; 答案&nbsp; =IF(ROW(A1)&gt;=COLUMN(A1),ROW(A1)&amp;"×"&amp;COLUMN(A1)&amp;"="&amp;ROW(A1)*COLUMN(A1),"")</p><p>第二题&nbsp;&nbsp;&nbsp; 答案&nbsp;= IF(AVERAGE(C32:E32)&lt;60,"不及格",IF(AND(60&lt;=AVERAGE(C32:E32),AVERAGE&nbsp;&nbsp;&nbsp;&nbsp; (C32:E32)&lt;=85),"及格",IF(85&lt;AVERAGE(C32:E32),"优秀")))</p><p>第三题&nbsp;&nbsp;&nbsp; 答案&nbsp; =IF(OR(D50="高级技师",D50="中级技师"),E50*0.4,E50*0.2)</p><p>第四题&nbsp;&nbsp; &nbsp;答案 &nbsp;==CELL("filename")</p>

qiqijiang

<p>4组059:qiqijiang交作业</p><p>1题：=ROW(A1)&amp;"*"&amp;COLUMN(A1)&amp;"="&amp;ROW(A1)*COLUMN(A1)</p><p>2题：=IF(SUM(C32+D32+E32)/3&lt;85,IF((C32+D32+E32)/3&gt;=60,"及格","不及格"),IF((C32+D32+E32)/3&gt;85,"优秀","及格"))</p><p>3题：=IF(OR(D50="高级技师",D50="中级技师"),E50*40%,E50*20%)</p><p>4题：=CELL("filename")</p><p>其他的题目还在思考呵呵，谢谢老师的批改</p>

学海泛舟

<p>4组049交作业，请老师批改！谢谢！</p><p></p><p><br/>第一题 =IF((ROW()-3)&gt;=(COLUMN()-1),(ROW()-3)&amp;"×"&amp;(COLUMN()-1)&amp;"="&amp;(ROW()-3)*(COLUMN()-1),"")<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =IF((ROW()-3)&lt;(COLUMN()-1),"",(ROW()-3)&amp;"×"&amp;(COLUMN()-1)&amp;"="&amp;(ROW()-3)*(COLUMN()-1))<br/>第二题 =IF(SUBTOTAL(1,C32:E32)&lt;60,"不及格",IF(SUBTOTAL(1,C32:E32)&lt;85,"及格","优秀"))<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =IF(AVERAGE(C32:E32)&lt;60,"不及格",IF(AVERAGE(C32:E32)&lt;85,"及格","优秀"))<br/>第三题 =IF(OR(D50="高级技师",D50="中级技师"),E50*40%,E50*20%)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =IF(NOT(OR(D50="高级技师",D50="中级技师")),E50*20%,E50*40%)<br/>第四题 =REPLACE(CELL("filename"),1,LEN(LEFT(CELL("filename"),FIND("]",CELL("filename")))),"")<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)<br/>选做题 =LEN(B4)*2-LENB(B4)</p>

juju桔桔

<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;函数入门班第5期学习班&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;四组&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 054交作业</p><p></p><p>第一题&nbsp;&nbsp;&nbsp; 答案&nbsp;&nbsp;&nbsp; =IF(ROW(A1)&gt;=COLUMN(A1),ROW(A1)&amp;"×"&amp;COLUMN(A1)&amp;"="&amp;ROW(A1)*COLUMN(A1),"")</p><p>第一题&nbsp;&nbsp;&nbsp; 答案&nbsp;&nbsp;&nbsp; &nbsp;=IF(AVERAGE(C32:E32)&lt;60,"不及格",IF(AND(60&lt;=AVERAGE(C32:E32),AVERAGE(C32:E32)&nbsp;&nbsp; &lt;=85),"及格",IF(85&lt;AVERAGE(C32:E32),"优秀")))</p><p>第一题&nbsp;&nbsp;&nbsp; 答案&nbsp;&nbsp;&nbsp; &nbsp;=IF(OR(D50="高级技师",D50="中级技师"),E50*0.4,E50*0.2)</p><p>&nbsp;第一题&nbsp;&nbsp;&nbsp; 答案&nbsp;&nbsp;&nbsp;&nbsp;=CELL("filename")</p><p></p>

加倍珍惜

<p>

游客，如果您要查看本帖隐藏内容请回复

</p><p><strong><font color="#ff0000">再忙也得抽上一小会时间做下作业</font></strong></p>[em01]

[此贴子已经被一剑惊心于2010-1-19 20:05:43编辑过]

yesmine

<div style="LINE-HEIGHT: 22px; HEIGHT: 22px;"><div style="FLOAT: left;"><img alt="发贴心情" src="http://www.excelpx.com/skins/Default/topicface/face1.gif"/></div><b>4组046号交作业</b></div><div style="MARGIN-TOP: 10px; FONT-SIZE: 9pt; MIN-HEIGHT: 200px; WORD-BREAK: break-all; TEXT-INDENT: 24px; LINE-HEIGHT: normal; WORD-WRAP: break-word;"><p>【第一题:不会做</p><p>【第二题】==IF(AVERAGE(C32:E32)&lt;60,"不及格",IF(AVERAGE(C32:E32)&gt;85,"优秀","合格"))</p><p>【第三题】==IF(OR(D50="高级技师",D50="中级技师"),E50*0.4,E50*0.2)</p><p>【第四题】==CELL("filename",B71),不过这个提取的是文件名,不是工作表名</p><p>【选做题】=不会做,不过我看网上有现成的公式,但因为不太理解,所以就依葫芦画瓢了.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p><p>[/hide]</p></div>