[求助] 社保四金的计算

aduo

每年都会碰到按照新的基数计算缴纳四金的金额，但是要见角进元之类的问题又出现了。以前在论坛看见过帖子解决的，现在找就找不到了。谢谢哪位高手能指点一下。

xolf

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>aduo</i>在2008-3-4 17:34:09的发言：</b><br/>每年都会碰到按照新的基数计算缴纳四金的金额，但是要见角进元之类的问题又出现了。以前在论坛看见过帖子解决的，现在找就找不到了。谢谢哪位高手能指点一下。</div><table cellspacing="0" cellpadding="0" width="566" border="0" style="WIDTH: 425pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="28" style="WIDTH: 21pt; mso-width-source: userset; mso-width-alt: 896;"></col><col span="3" width="76" style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2432;"></col><col width="310" style="WIDTH: 233pt; mso-width-source: userset; mso-width-alt: 9920;"></col></colgroup><tbody><tr height="18" style="HEIGHT: 13.5pt;"><td class="xl68" width="28" height="18" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 21pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: #95b3d7;"><font face="宋体">　</font></td><td class="xl73" width="76" style="BORDER-RIGHT: #8db4e3 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 57pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #dbe5f1;"><font face="宋体"><span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp; </span>A</font></td><td class="xl74" width="76" style="BORDER-RIGHT: #8db4e3 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #8db4e3; WIDTH: 57pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #dbe5f1;"><font face="宋体"><span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp; </span>B</font></td><td class="xl69" width="76" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #dbe5f1;"><font face="宋体"><span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp; </span>C</font></td><td class="xl74" width="310" style="BORDER-RIGHT: #8db4e3 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #8db4e3 0.5pt solid; WIDTH: 233pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #dbe5f1;"><font face="宋体"><span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; </span>D</font></td></tr><tr height="62" style="HEIGHT: 46.5pt; mso-height-source: userset;"><td class="xl70" height="62" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #8db4e3 0.5pt solid; HEIGHT: 46.5pt; BACKGROUND-COLOR: #dbe5f1;"><font face="宋体">&nbsp;1</font></td><td class="xl65" width="76" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fcd5b4;"><font face="宋体">养老保险</font></td><td class="xl66" width="76" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #ece9d8; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fcd5b4;"><font face="宋体">养老保险个人缴费比例8％</font></td><td class="xl65" width="76" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fcd5b4;"><font face="宋体">保留</font></td><td class="xl65" width="310" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 233pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fcd5b4;"><font face="宋体">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 函数</font></td></tr><tr height="38" style="HEIGHT: 28.5pt; mso-height-source: userset;"><td class="xl72" height="38" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #8db4e3; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 28.5pt; BACKGROUND-COLOR: #dbe5f1;"><font face="宋体">&nbsp;2</font></td><td class="xl75" width="76" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext; WIDTH: 57pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">1807.00 </font></td><td class="xl76" width="76" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 57pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">144.56 </font></td><td class="xl76" width="76" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 57pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">145.00 </font></td><td class="xl67" width="310" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 233pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">四舍五入：=ROUND(B2,0)</font></td></tr><tr height="38" style="HEIGHT: 28.5pt; mso-height-source: userset;"><td class="xl70" height="38" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #8db4e3 0.5pt solid; HEIGHT: 28.5pt; BACKGROUND-COLOR: #dbe5f1;"><font face="宋体">&nbsp;3</font></td><td class="xl75" width="76" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext; WIDTH: 57pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">2780.00 </font></td><td class="xl76" width="76" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 57pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">222.40 </font></td><td class="xl76" width="76" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 57pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">223.00 </font></td><td class="xl67" width="310" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 233pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">见角进元：=CEILING(TRUNC(B3,1),1)</font></td></tr><tr height="38" style="HEIGHT: 28.5pt; mso-height-source: userset;"><td class="xl71" height="38" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 28.5pt; BACKGROUND-COLOR: #dbe5f1;"><font face="宋体">&nbsp;4　</font></td><td class="xl75" width="76" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext; WIDTH: 57pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">2501.00 </font></td><td class="xl76" width="76" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 57pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">200.08 </font></td><td class="xl76" width="76" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 57pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">200.00 </font></td><td class="xl67" width="310" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 233pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 见角进元，见分则不进。</font></td></tr><tr height="38" style="HEIGHT: 28.5pt; mso-height-source: userset;"><td class="xl72" height="38" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #8db4e3 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 28.5pt; BACKGROUND-COLOR: #dbe5f1;"><font face="宋体">&nbsp;5</font></td><td class="xl75" width="76" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext; WIDTH: 57pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">1701.00 </font></td><td class="xl76" width="76" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 57pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">136.08 </font></td><td class="xl77" align="right" width="76" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 57pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><div style="OVERFLOW-X: hidden; WORD-WRAP: break-word;"><font face="Tahoma" size="2">136.00 </font></div></td><td class="xl67" width="310" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 233pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">见角进元2：=RMB(B5,0)</font></td></tr></tbody></table>

[此贴子已经被作者于2008-3-5 9:37:39编辑过]

aduo

<p>谢谢了!!!</p>

lytton_lee

见角进元，见分则不进=ROUNDUP(TRUNC(b4,1),0)

xjjun_cy

ROUNDUP(TRUNC(A1,1),)

candy88832

<p>我是上海地区的，我们这里是见分进角的，不知道公式是怎么样的，和社保中心算出来的总是不一样，差个几毛钱，不明白他们是每个人见分进角呢，还是所有的值保留2位小数然后加起来的总和加在一起见分进角，哪位大师指点一下，谢谢！</p>

xolf

<p>若见分进角。</p><p>＝roundup（a1，1）</p><p>上海地区社保中心算法不太清楚，不敢妄言，应该是个人 见分进角？</p>

nocrying

<p>上海是个人部分见分进角，用roundup（A1，1），单位部分四舍五入，用round（A1,1)。</p><p>呵呵，我昨天刚全部调完社保</p>

selina_zlh

城保：个人每单项见分进角，单位每单项合计见分进角（eg：单位养老部分全部合计后再见分进角）
镇保: 每单项见分进角

[ 本帖最后由 selina_zlh 于 2009-8-10 22:01 编辑 ]

wenwen000424

记下,