Excel精英培训网

 找回密码
 注册
数据透视表40+个常用小技巧,让你一次学会!
楼主: 开辆小富康

[通知] 函入6期第1讲作业上交贴(1、2组)

[复制链接]
发表于 2010-8-9 07:58 | 显示全部楼层

函入6期班1组1号交作业

游客,如果您要查看本帖隐藏内容请回复
excel精英培训的微信平台,每天都会发送excel学习教程和资料。扫一扫明天就可以收到新教程
回复

使用道具 举报

发表于 2010-8-9 10:38 | 显示全部楼层

函入6期班2组28号交作业

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

使用道具 举报

发表于 2010-8-9 12:12 | 显示全部楼层

<p>02022 hyhhh</p><p>
游客,如果您要查看本帖隐藏内容请回复
</p><p></p>
回复

使用道具 举报

发表于 2010-8-9 19:03 | 显示全部楼层

函入6期班1组05号交作业

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

使用道具 举报

发表于 2010-8-9 21:08 | 显示全部楼层

[em01][em01]
回复

使用道具 举报

发表于 2010-8-9 21:42 | 显示全部楼层

代函入6期1班2组017号交作业

<p>2组017号同学因为临时有事,来不及交作业,让我代交。请学委批改!</p><p>
游客,如果您要查看本帖隐藏内容请回复
<br/></p>
回复

使用道具 举报

发表于 2010-8-10 08:05 | 显示全部楼层

函入6期班2组020号交作业

<p></p><p>请老师批阅</p><p>
游客,如果您要查看本帖隐藏内容请回复
回复

使用道具 举报

发表于 2010-8-10 09:36 | 显示全部楼层

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

使用道具 举报

发表于 2010-8-10 09:54 | 显示全部楼层

函入6期1组003号交作业

<p>答案在楼上。</p><p>辛苦老师了,谢谢!!!!</p>[em23][em23][em23][em24][em25][em26][em27]
[此贴子已经被作者于2010-8-10 10:00:42编辑过]
回复

使用道具 举报

发表于 2010-8-10 13:22 | 显示全部楼层

<p>函入6期O1O12</p><p>第一题</p><table cellspacing="0" cellpadding="0" width="862" border="0" style="WIDTH: 647pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="120" style="WIDTH: 90pt; mso-width-source: userset; mso-width-alt: 1920;"></col><col width="248" style="WIDTH: 186pt; mso-width-source: userset; mso-width-alt: 3968;"></col><col width="222" style="WIDTH: 167pt; mso-width-source: userset; mso-width-alt: 3552;"></col><col width="272" style="WIDTH: 204pt; mso-width-source: userset; mso-width-alt: 4352;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl72" width="862" colspan="4" height="19" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #ebe9ed; WIDTH: 647pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">**学校三1班学生成绩统计表</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">姓名</td><td class="xl68" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">语文</td><td class="xl68" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">数学</td><td class="xl68" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">英语</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">参考人数</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=COUNTIF(C3:C30,"&lt;&gt;缺考")</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=COUNTIF(D3:D30,"&lt;&gt;缺考")</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=COUNTIF(E3:E30,"&lt;&gt;缺考")</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">总分</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=SUM(C3:C30)</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=SUM(D3:D30)</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=SUM(E3:E30)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">平均分</td><td class="xl70" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=AVERAGE(C3:C30)</td><td class="xl70" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=AVERAGE(D3:D30)</td><td class="xl70" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=AVERAGE(E3:E30)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">及格人数</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=COUNTIF(C3:C30,"&gt;59")</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=COUNTIF(D3:D30,"&gt;59")</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=COUNTIF(E3:E30,"&gt;59")</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">及格率</td><td class="xl71" xfmla="=B6/B3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=C36/C33</td><td class="xl71" xfmla="=C6/C3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=D36/D33</td><td class="xl71" xfmla="=D6/D3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=E36/E33</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">优秀人数</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=COUNTIF(C3:C30,"&gt;=85")</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=COUNTIF(D3:D30,"&gt;=85")</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=COUNTIF(E3:E30,"&gt;=85")</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">优秀率</td><td class="xl71" xfmla="=B8/B3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=C38/C33</td><td class="xl71" xfmla="=C8/C3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=D38/D33</td><td class="xl71" xfmla="=D8/D3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=E38/E33</td></tr></tbody></table><p></p><p>第二题</p><p><table cellspacing="0" cellpadding="0" width="556" border="0" style="WIDTH: 417pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="108" style="WIDTH: 81pt; mso-width-source: userset; mso-width-alt: 1728;"></col><col width="160" style="WIDTH: 120pt; mso-width-source: userset; mso-width-alt: 2560;"></col><col span="2" width="144" style="WIDTH: 108pt;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" width="108" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 81pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">科目</td><td class="xl68" width="160" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 120pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">语文</td><td class="xl68" width="144" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 108pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">数学</td><td class="xl68" width="144" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 108pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">英语</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">最高分</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=MAX(第1题!C3:C30)</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=MAX(第1题!D3:D30)</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=MAX(第1题!E3:E30)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">最低分</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=MIN(第1题!C3:C30)</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=MIN(第1题!D3:D30)</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=MIN(第1题!E3:E30)</td></tr></tbody></table></p><p>第三题</p><p><table cellspacing="0" cellpadding="0" width="256" border="0" style="WIDTH: 192pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="256" style="WIDTH: 192pt; mso-width-source: userset; mso-width-alt: 4096;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl69" width="256" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 192pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">结余(累计)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #ffcc99;">=SUM($C$2:C2)-SUM($D$2:D2)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #ffcc99;">=SUM($C$2:C3)-SUM($D$2:D3)</td></tr></tbody></table></p><p>选做题</p><p><table cellspacing="0" cellpadding="0" width="246" border="0" style="WIDTH: 185pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="246" style="WIDTH: 185pt; mso-width-source: userset; mso-width-alt: 3936;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" width="246" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 185pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">计算结果</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl69" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;">=SUM(A7,B7&amp;C7,D7&amp;E7)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl69" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;">=SUM(A8,B8&amp;C8,D8&amp;E8)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl69" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;">=SUM(A9,B9&amp;C9,D9&amp;E9)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl69" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;">=SUM(A10,B10&amp;C10,D10&amp;E10)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl69" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;">=SUM(A11,B11&amp;C11,D11&amp;E11)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl69" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;">=SUM(A12,B12&amp;C12,D12&amp;E12)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl69" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;">=SUM(A13,B13&amp;C13,D13&amp;E13)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl69" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;">=SUM(A14,B14&amp;C14,D14&amp;E14)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl69" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;">=SUM(A15,B15&amp;C15,D15&amp;E15)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl69" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;">=SUM(A16,B16&amp;C16,D16&amp;E16)</td></tr></tbody></table></p><p><table cellspacing="0" cellpadding="0" width="204" border="0" style="WIDTH: 153pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="204" style="WIDTH: 153pt; mso-width-source: userset; mso-width-alt: 3264;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" width="204" height="19" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 153pt; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: #ffcc99;">=C2-D2+IF(E1=$E$1,0,E1)</td></tr></tbody></table></p><p></p>
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )

GMT+8, 2024-5-9 09:03 , Processed in 0.321846 second(s), 11 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表