[有奖答题]中文式函数(还有19BB)

excel-lch · 发表于 2008-12-5 20:10

<table cellspacing="0" cellpadding="0" width="413" border="0" xstr="" style="WIDTH: 311pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="34" style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1088;"></col><col></col><col></col><col></col><col width="50" style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1600;"></col><col></col><col></col><col></col><col width="107" style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3424;"></col><col></col><col></col><col></col><col width="100" style="WIDTH: 75pt; mso-width-source: userset; mso-width-alt: 3200;"></col><col></col><col></col><col></col><col width="122" style="WIDTH: 92pt; mso-width-source: userset; mso-width-alt: 3904;"></col><col></col><col></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl29" width="34" height="19" style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; WIDTH: 26pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: silver;">　</td><td class="xl30" width="50" style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray; WIDTH: 38pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: silver;">A</td><td class="xl30" width="107" style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray; WIDTH: 80pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: silver;">B</td><td class="xl30" width="100" style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray; WIDTH: 75pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: silver;">C</td><td class="xl30" width="122" style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray; WIDTH: 92pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: silver;">D</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl30" height="19" xnum="" style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: silver;">1</td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #99ccff;">姓名</td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #99ccff;">应发工资</td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #99ccff;">扣税</td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #99ccff;">实发工资</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl30" height="19" xnum="" style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: silver;">2</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #ffffff; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">张三</td><td class="xl24" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">700</td><td class="xl24" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">10</td><td class="xl25" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">690</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl30" height="19" xnum="" style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: silver;">3</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #ffffff; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">A2</td><td class="xl24" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">750</td><td class="xl24" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">20</td><td class="xl25" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">730</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl30" height="19" xnum="" style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: silver;">4</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #ffffff; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">A3</td><td class="xl24" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">800</td><td class="xl24" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">30</td><td class="xl25" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">770</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl30" height="19" xnum="" style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: silver;">5</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #ffffff; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">A4</td><td class="xl24" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">850</td><td class="xl24" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">40</td><td class="xl25" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">810</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl30" height="19" xnum="" style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: silver;">6</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #ffffff; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">A5</td><td class="xl24" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">900</td><td class="xl24" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">50</td><td class="xl25" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">850</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl30" height="19" xnum="" style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: silver;">7</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #ffffff; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">A6</td><td class="xl24" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">950</td><td class="xl24" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">60</td><td class="xl25" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">890</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl30" height="19" xnum="" style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: silver;">8</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #ffffff; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">A7</td><td class="xl24" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">1000</td><td class="xl24" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">70</td><td class="xl25" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">930</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl30" height="19" xnum="" style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: silver;">9</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #ffffff; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">A8</td><td class="xl24" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">1050</td><td class="xl24" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">80</td><td class="xl25" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">970</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl30" height="19" xnum="" style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: silver;">10</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #ffffff; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">A9</td><td class="xl24" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">1100</td><td class="xl24" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">90</td><td class="xl25" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">1010</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl30" height="19" xnum="" style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: silver;">11</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #ffffff; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">合计</td><td class="xl25" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">8100</td><td class="xl25" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">450</td><td class="xl25" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">7650</td></tr></tbody></table>题目：用公式求出实发工资及项目合计，结果如上表要求：1.不能使用定义名称2.除使用公式运算符及函数本身外，其它均使用中文文字（行表头或列表头中的文字）3.不能使用VBA，只用Excel基本功能！4.如本版上方规定发贴

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

[此贴子已经被作者于2008-12-7 14:31:10编辑过]

一剑惊心 · 发表于 2008-12-5 20:13

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

雨雷 · 发表于 2008-12-5 20:27

什么意思啊

tobylee · 发表于 2008-12-5 20:39

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

tobylee · 发表于 2008-12-5 20:40

哦，上面公式多了一个等号。[em06]

Q稻草人Q · 发表于 2008-12-5 20:51

偶不会,顶一下[em02]

goo · 发表于 2008-12-5 20:59

学习下。。看不懂题目

勤快的猫 · 发表于 2008-12-5 21:15

在D1输入：=B1-C1向下填充

绝峰 · 发表于 2008-12-5 21:20

看看

美美128 · 发表于 2008-12-5 22:10

学习了

		自动登录	找回密码
密码			注册

[有奖答题]中文式函数(还有19BB)

浏览过的版块