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

gangwan

<p>看不懂，学习一下</p>

excel-lch

<p><font color="#ff0000">还有19BB，大家回复加大奖励力度！</font></p>[em01]

jsszdl6

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

<table cellspacing="0" cellpadding="0" width="364" border="0" xstr="" style="WIDTH: 273pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="64" style="WIDTH: 48pt;"></col><col width="93" style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 3401;"></col><col width="111" style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 4059;"></col><col width="96" style="WIDTH: 72pt; mso-width-source: userset; mso-width-alt: 3510;"></col></colgroup><tbody><tr height="16" style="HEIGHT: 12pt;"><td class="xl22" width="64" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: #99ccff;"><div style="MIN-HEIGHT: 200px; WORD-WRAP: break-word;"><font face="宋体" size="2">姓名</font></div></td><td class="xl22" width="93" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 70pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #99ccff;"><font face="宋体" size="2">应发工资</font></td><td class="xl22" width="111" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 83pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #99ccff;"><font face="宋体" size="2">扣税</font></td><td class="xl22" width="96" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 72pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #99ccff;"><font face="宋体" size="2">实发工资</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl23" width="64" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">张三</font></td><td class="xl24" width="93" xnum="" xstr="'=(ROW()-1)*70" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 70pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">=(ROW()-1)*70</font></td><td class="xl24" width="111" xnum="" xstr="'=(ROW()-1)*10" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 83pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">=(ROW()-1)*10</font></td><td class="xl26" width="96" xnum="" xstr="'=B2-C2" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 72pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" size="2">=B2-C2</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl23" width="64" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">A2</font></td><td class="xl25" width="93" xnum="" xstr="'=B2+50" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 70pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">=B2+50</font></td><td class="xl24" width="111" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 83pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">=C2+10</font></td><td class="xl26" width="96" xnum="" xstr="'=B3-C3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 72pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" size="2">=B3-C3</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl23" width="64" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">A3</font></td><td class="xl25" width="93" xnum="" xstr="'=B3+50" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 70pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">=B3+50</font></td><td class="xl24" width="111" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 83pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">=C2+11</font></td><td class="xl26" width="96" xnum="" xstr="'=B4-C4" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 72pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" size="2">=B4-C4</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl23" width="64" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">A4</font></td><td class="xl25" width="93" xnum="" xstr="'=B4+50" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 70pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">=B4+50</font></td><td class="xl24" width="111" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 83pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">=C2+12</font></td><td class="xl26" width="96" xnum="" xstr="'=B5-C5" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 72pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" size="2">=B5-C5</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl23" width="64" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">A5</font></td><td class="xl25" width="93" xnum="" xstr="'=B5+50" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 70pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">=B5+50</font></td><td class="xl24" width="111" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 83pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">=C2+13</font></td><td class="xl26" width="96" xnum="" xstr="'=B6-C6" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 72pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" size="2">=B6-C6</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl23" width="64" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">A6</font></td><td class="xl25" width="93" xnum="" xstr="'=B6+50" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 70pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">=B6+50</font></td><td class="xl24" width="111" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 83pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">=C2+14</font></td><td class="xl26" width="96" xnum="" xstr="'=B7-C7" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 72pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" size="2">=B7-C7</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl23" width="64" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">A7</font></td><td class="xl25" width="93" xnum="" xstr="'=B7+50" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 70pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">=B7+50</font></td><td class="xl24" width="111" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 83pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">=C2+15</font></td><td class="xl26" width="96" xnum="" xstr="'=B8-C8" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 72pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" size="2">=B8-C8</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl23" width="64" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">A8</font></td><td class="xl25" width="93" xnum="" xstr="'=B8+50" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 70pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">=B8+50</font></td><td class="xl24" width="111" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 83pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">=C2+16</font></td><td class="xl26" width="96" xnum="" xstr="'=B9-C9" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 72pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" size="2">=B9-C9</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl23" width="64" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">A9</font></td><td class="xl25" width="93" xnum="" xstr="'=B9+50" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 70pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">=B9+50</font></td><td class="xl24" width="111" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 83pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">=C2+17</font></td><td class="xl26" width="96" xnum="" xstr="'=B10-C10" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 72pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" size="2">=B10-C10</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl23" width="64" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">合计</font></td><td class="xl26" width="93" xnum="" xstr="'=SUM(B2:B10)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 70pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" size="2">=SUM(B2:B10)</font></td><td class="xl26" width="111" xnum="" xstr="'=SUM(C2:C10)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 83pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" size="2">=SUM(C2:C10)</font></td><td class="xl26" width="96" xnum="" xstr="'=SUM(D2:D10)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 72pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" size="2">=SUM(D2:D10)</font> <div></div></td></tr></tbody></table>

wjh619993018

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

[此贴子已经被作者于2008-12-18 14:09:16编辑过]

w1098

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

linmuquanyy

<p>来看</p>

爱疯

<p>不懂哦</p>

jh_richey

学习一下

rqan

直接看答案

xiaoni

good