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

雨林

<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 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 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>1<span lang="EN-US" style="FONT-FAMILY: 宋体; mso-hansi-font-family: tahoma; mso-ascii-font-family: tahoma;"><span lang="EN-US">月</span></span>13<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 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 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><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: tahoma;"><br/>&nbsp;&nbsp;&nbsp;<p></p></span></p><p></p><p></p><p></p>

[此贴子已经被作者于2010-1-12 19:48:29编辑过]

陈丹红

<p>第一题=ROW(A1)&amp;"X"&amp;COLUMN(A1)&amp;"="&amp;ROW(A1)*COLUMN(A1)</p><p>第二题：平均销量=ROUND(SUBTOTAL(1,D28:D36),2)</p><p>合计销量：=SUBTOTAL(9,D28:D36)</p><p>最大销量：=SUBTOTAL(4,D28:D36)</p><p>最小销量：=SUBTOTAL(5,D28:D36)</p><p>第三题：奖金=(C73&lt;=100000)*0.01+(C73&gt;100000)*(C73*0.02-100000*0.01)</p><p>第四题：省了第三个函数</p>

金山独霸

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

[此贴子已经被作者于2010-1-12 22:12:47编辑过]

xcslp

<p>1组161上交作业</p><p><table cellspacing="0" cellpadding="0" width="565" border="0" style="WIDTH: 424pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="3" width="72" style="WIDTH: 54pt;"></col><col width="61" style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 1952;"></col><col span="4" width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" width="72" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;"><a name="RANGE!A1"><strong><font face="宋体" color="#0000ff">　</font></strong></a></td><td width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><strong><font face="宋体" color="#0000ff"></font></strong></td><td class="xl28" width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><strong><font face="宋体" color="#0000ff"></font></strong></td><td width="61" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 46pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><strong><font face="宋体" color="#0000ff"></font></strong></td><td width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><strong><font face="宋体" color="#0000ff"></font></strong></td><td width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><strong><font face="宋体" color="#0000ff"></font></strong></td><td class="xl26" width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><strong><font face="宋体" color="#0000ff"></font></strong></td><td class="xl26" width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><strong><font face="宋体" color="#0000ff"></font></strong></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td align="right" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">1</font></td><td class="xl28" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td colspan="4" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><font face="宋体">$A2&amp;"×"&amp;B$11&amp;"="&amp;$A2*B$11</font></td><td class="xl26" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td class="xl26" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td align="right" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">2</font></td><td class="xl28" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td colspan="3" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><font face="宋体">SUBTOTAL(9,D28:D36)</font></td><td colspan="3" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><font face="宋体">SUBTOTAL(9,D28:D36)</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td class="xl28" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td colspan="3" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><font face="宋体">SUBTOTAL(4,D30:D38)</font></td><td colspan="3" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><font face="宋体">SUBTOTAL(5,D31:D39)</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td align="right" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">3</font></td><td class="xl28" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td colspan="3" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><font face="宋体">(C72-100000)*0.02</font></td><td class="xl26" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td class="xl26" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td class="xl26" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td class="xl26" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td class="xl26" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td class="xl26" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td class="xl26" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体">C74*0.01</font></td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td class="xl26" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td class="xl26" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td class="xl26" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td class="xl26" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td class="xl26" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td class="xl26" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td class="xl26" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td class="xl26" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td class="xl28" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td></tr><tr height="20" style="HEIGHT: 15pt;"><td align="right" height="20" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent;"><font face="宋体">4</font></td><td class="xl29" colspan="2" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent; mso-ignore: colspan;">MATCH(1,{1,2,3},)&nbsp;&nbsp;</td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"></td></tr><tr height="20" style="HEIGHT: 15pt;"><td height="20" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent;"></td><td class="xl29" colspan="3" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent; mso-ignore: colspan;">MATCH(1,{1,2,3})&nbsp;&nbsp;<font class="font6" face="宋体">模糊查找</font></td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"></td></tr></tbody></table></p>

tu343740603

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

[此贴子已经被作者于2010-1-12 22:22:27编辑过]

A0745

<p>&nbsp;</p> xI421Iz4.rar (27.92 KB, 下载次数: 1)

2010-1-13 14:06 上传

点击文件名下载附件
[ 习题 ] 【函入5期1班】第1讲作业补交帖 <br/>

zhigang45

<p>第一题=ROW(A1)&amp;"X"&amp;COLUMN(A1)&amp;"="&amp;ROW(A1)*COLUMN(A1)</p><p>第二题：平均销量=ROUND(SUBTOTAL(1,D28:D36),2)</p><p>合计销量：=SUBTOTAL(9,D28:D36)</p><p>最大销量：=SUBTOTAL(4,D28:D36)</p><p>最小销量：=SUBTOTAL(5,D28:D36)</p><p></p><p></p>

excel学生

<p>1、</p><p>2、=SUBTOTAL(9,D28:D36)</p><p>=SUBTOTAL(1,D28:D36)</p><p>=SUBTOTAL(4,D28:D36)</p><p>=SUBTOTAL(5,D28:D36)</p><p>3、=(C71&lt;=100000)*(C71*0.01)+(C71&gt;100000)*(C71*0.02-100000*0.01)</p><p>4、第一个是有三个量，第三个量省略了</p>

vbyou127

fggfdfd