xgdiscover
发表于 2008-8-31 20:33
[有奖练习题]技巧操作
<p>如图:为什么工资合计额与显示的金额相差0.01元呢,如何一致.写出步骤即可.</p><p><font color="#0066ff" size="6">做对前三者每人奖<strong>2BB</strong></font>.</p><p>要求:<font color="#ff0000" size="6">1.奖励对象只限"综1系2期3班"成员</font></p><p><font color="#ff0000" size="6"> 2采用回复贴方式上传操作步骤.否则答案无效</font></p><p> </p><p> </p><p><br/></p>
[此贴子已经被作者于2008-8-31 22:02:09编辑过]
yvhanym
发表于 2008-8-31 20:51
设置单元格格式
shaoxiuzhang
发表于 2008-8-31 20:53
<p>用SUM计算对的呀，怎么会是200呢？</p><p><table cellspacing="0" cellpadding="0" width="216" border="0" xstr="" style="WIDTH: 162pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="3" width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl25" width="216" colspan="3" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 162pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体">工资表</font></p></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" 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;"><font face="宋体"> </font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">月份</font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">工资额</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" 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;"><p align="center"><font face="宋体">王五</font></p></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;"><p align="center"><font face="宋体">1</font></p></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;"><p align="center"><font face="宋体">66.67</font></p></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" 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;"><p align="center"><font face="宋体">王五</font></p></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;"><p align="center"><font face="宋体">2</font></p></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;"><p align="center"><font face="宋体">66.67</font></p></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" 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;"><p align="center"><font face="宋体">王五</font></p></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;"><p align="center"><font face="宋体">3</font></p></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;"><p align="center"><font face="宋体">66.67</font></p></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl25" colspan="2" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体">合计</font></p></td><td class="xl24" align="right" xnum="" xfmla="=SUM(C3:C5)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体">200.01</font></p></td></tr></tbody></table></p>
牙痒痒
发表于 2008-8-31 21:47
楼主怎么会算出200的呢，我跟楼上的一样，是200.01哦。<br/><img src="http://www.excelpx.com/UploadFile/2008-8/200883121454797431.gif" border="0" alt=""/>
baojianming
发表于 2008-9-1 09:07
原因及答案
**** Hidden Message *****
yadog
发表于 2008-9-1 10:11
good
yuanfang1025
发表于 2008-9-1 10:27
试下
**** Hidden Message *****
hnpyhjh
发表于 2008-9-1 11:04
我也不清楚，还是好好学习吧!
flocc
发表于 2008-9-1 13:00
学习
AK_may
发表于 2008-9-1 13:31
<p>奇怪,我算的也是200.01啊,是不是哪里搞错了?</p>