[ 习题 ] 【函入5期1班】第3讲作业补交帖

雨林

<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;"><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 style="BACKGROUND: white; WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="3"><strong><span lang="EN-US" style="COLOR: #ff6600; FONT-FAMILY: tahoma;">1</span></strong><strong><span style="COLOR: #ff6600; FONT-FAMILY: 宋体; mso-hansi-font-family: tahoma; mso-bidi-font-family: tahoma; mso-ascii-font-family: tahoma;">、请用回复可见贴形式上交作业后不能修改；</span></strong><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: tahoma;"><br/>&nbsp;&nbsp;&nbsp;&nbsp; <p></p></span></font></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p style="BACKGROUND: white; WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="3"><strong><span lang="EN-US" style="COLOR: #ff6600; FONT-FAMILY: tahoma;">2</span></strong><strong><span style="COLOR: #ff6600; FONT-FAMILY: 宋体; mso-hansi-font-family: tahoma; mso-bidi-font-family: tahoma; mso-ascii-font-family: tahoma;">、非本班成员严禁回复，一经发现按抄袭论处，删贴扣币币；</span></strong><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: tahoma;"><br/>&nbsp;&nbsp;&nbsp;&nbsp; <p></p></span></font></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p style="BACKGROUND: white; WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="3"><strong><span lang="EN-US" style="COLOR: #ff6600; FONT-FAMILY: tahoma;">3</span></strong><strong><span style="COLOR: #ff6600; FONT-FAMILY: 宋体; mso-hansi-font-family: tahoma; mso-bidi-font-family: tahoma; mso-ascii-font-family: tahoma;">、作业上交截止时间为</span></strong><strong><span lang="EN-US" style="COLOR: #ff6600; FONT-FAMILY: tahoma;"><chsdate year="2010" month="1" day="12" islunardate="False" isrocdate="False" wst="on"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate>1<span lang="EN-US" style="FONT-FAMILY: 宋体; mso-hansi-font-family: tahoma; mso-ascii-font-family: tahoma;"><span lang="EN-US">月</span></span>27<span lang="EN-US" style="FONT-FAMILY: 宋体; mso-hansi-font-family: tahoma; mso-ascii-font-family: tahoma;"><span lang="EN-US">日</span></span>17</span></strong><strong><span style="COLOR: #ff6600; FONT-FAMILY: 宋体; mso-hansi-font-family: tahoma; mso-bidi-font-family: tahoma; mso-ascii-font-family: tahoma;">点；</span></strong><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: tahoma;"><br/>&nbsp;&nbsp;&nbsp;&nbsp; <p></p></span></font></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p style="BACKGROUND: white; WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="3"><strong><span lang="EN-US" style="COLOR: #ff6600; FONT-FAMILY: tahoma;">4</span></strong><strong><span style="COLOR: #ff6600; FONT-FAMILY: 宋体; mso-hansi-font-family: tahoma; mso-bidi-font-family: tahoma; mso-ascii-font-family: tahoma;">、补交作业学员上交10个金币，未交金币或交白卷的视为未交作业；</span></strong><strong><span lang="EN-US" style="COLOR: #ff6600; FONT-FAMILY: tahoma;"><br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <p></p></span></strong></font></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p style="BACKGROUND: white; WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="3"><strong><span lang="EN-US" style="COLOR: #ff6600; FONT-FAMILY: tahoma;">5</span></strong><strong><span style="COLOR: #ff6600; FONT-FAMILY: 宋体; mso-hansi-font-family: tahoma; mso-bidi-font-family: tahoma; mso-ascii-font-family: tahoma;">、上交好作业后再投票</span></strong><strong><span lang="EN-US" style="COLOR: #ff6600; FONT-FAMILY: tahoma;">(</span></strong><strong><span style="COLOR: #ff6600; FONT-FAMILY: 宋体; mso-hansi-font-family: tahoma; mso-bidi-font-family: tahoma; mso-ascii-font-family: tahoma;">非本班成员严禁投票</span></strong><strong><span lang="EN-US" style="COLOR: #ff6600; FONT-FAMILY: tahoma;">)</span></strong><strong><span style="COLOR: #ff6600; FONT-FAMILY: 宋体; mso-hansi-font-family: tahoma; mso-bidi-font-family: tahoma; mso-ascii-font-family: tahoma;">。</span></strong></font></p></div></div>

白色紫薇

<table cellspacing="0" cellpadding="0" width="939" border="0" style="WIDTH: 704pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="939" style="WIDTH: 704pt; mso-width-source: userset; mso-width-alt: 30048;"></col></colgroup><tbody><tr height="20" style="HEIGHT: 15pt;"><td class="xl67" width="939" height="20" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 704pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent;">

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

</td></tr></tbody></table>

白色紫薇

<table cellspacing="0" cellpadding="0" width="939" border="0" style="WIDTH: 704pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="939" style="WIDTH: 704pt; mso-width-source: userset; mso-width-alt: 30048;"></col></colgroup><tbody><tr height="20" style="HEIGHT: 15pt;"><td class="xl67" width="939" height="20" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 704pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent;">

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

</td></tr></tbody></table>

meg19850305

咋办呢 不会写 ，只会写第一题，而且不是函数办法，

maolao848

<p>6组083</p><p>

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

</p>

maolao848

<p>

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

</p>

tu343740603

<p>1组174交作业来了！</p><p>

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

[em01]

ritter0921

<p>4组047补交作业</p><p>

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

qiqijiang

<p>059 4组补交作业 </p><p>一</p><p>1，=SUMPRODUCT((数据!$B$2:$B$1339=必做题!C$6)*(数据!$C$2:$C$1339=必做题!$B7),数据!$D$2:$D$1339)</p><p>2，=SUMPRODUCT((数据!C2:C1339="A")*(数据!E2:E1339&gt;4),数据!F2:F1339)</p><p>3，=SUMPRODUCT(((数据!C2:C1339="A")+(数据!C2:C1339="B")+(数据!C2:C1339="C"))*(数据!B2:B1339="甲")*(数据!F2:F1339))</p><p>二</p><p>1，=SUM(IF(MOD(ROW(1:1000),2)=1,ROW(1:1000)))加三键</p><p>2，=MOD(ROW(1:6)-1,3)+1加三键</p><p>还在思考</p>

echolan

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