有关求整

ycoco

<p>我公司发放工资比较麻烦，每月只发到50元止。不足40元的余额转入下月，40元的呢就让大家找回。</p><p>我对应设置了一下求整公式，但是太繁杂，不容易教会大家，请大家整和一下公式。谢谢！</p> eaD8XsUU.rar (1.87 KB, 下载次数: 6)

2007-1-3 12:15 上传

点击文件名下载附件
有关求整

<br/>

ycoco

可能大家不喜欢下载，我将公式粘上，请大家帮忙整合一下，或者给更好的公式，谢谢！<table cellspacing="0" cellpadding="0" width="567" border="0" style="WIDTH: 426pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="39" style="WIDTH: 29pt; mso-width-source: userset; mso-width-alt: 1248;"></col><col width="38" style="WIDTH: 29pt; mso-width-source: userset; mso-width-alt: 1216;"></col><col width="108" style="WIDTH: 81pt; mso-width-source: userset; mso-width-alt: 3456;"></col><col width="128" style="WIDTH: 96pt; mso-width-source: userset; mso-width-alt: 4096;"></col><col width="142" style="WIDTH: 107pt; mso-width-source: userset; mso-width-alt: 4544;"></col><col width="60" style="WIDTH: 45pt; mso-width-source: userset; mso-width-alt: 1920;"></col><col width="52" style="WIDTH: 39pt; mso-width-source: userset; mso-width-alt: 1664;"></col></colgroup><tbody><tr height="33" style="HEIGHT: 24.75pt; mso-height-source: userset;"><td class="xl24" width="39" height="33" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 29pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 24.75pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">姓名</font></td><td class="xl25" width="38" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 29pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font face="宋体" size="2">应发</font></td><td class="xl25" width="108" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 81pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font size="2"><font face="宋体">求整</font><font class="font7" face="Times New Roman">1</font></font></td><td class="xl25" width="128" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 96pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font size="2"><font face="宋体">求整</font><font class="font7" face="Times New Roman">2</font></font></td><td class="xl25" width="142" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 107pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font size="2"><font face="宋体">求整</font><font class="font7" face="Times New Roman">3</font></font></td><td class="xl26" width="60" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 45pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">本期实发</font></td><td class="xl27" width="52" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 39pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">余数</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl24" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">谢谢</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">1098 </font></td><td class="xl28" 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 size="2"><span style="mso-spacerun: yes;">&nbsp;</span>=ROUNDDOWN(C2,-2)</font></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 size="2"><span style="mso-spacerun: yes;">&nbsp;</span>=IF((C2-D2)&gt;39,50,0)</font></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 size="2"><span style="mso-spacerun: yes;">&nbsp;</span>=IF((C2-D2-E2)&gt;39,50,0)</font></font></td><td class="xl29" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2"><span style="mso-spacerun: yes;"><font face="Times New Roman">&nbsp;</font></span><font class="font6" face="宋体">=C2+D2+E2</font></font></td><td class="xl30" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2"><span style="mso-spacerun: yes;"><font face="Times New Roman">&nbsp;</font></span><font class="font6" face="宋体">=B2-F2</font></font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl24" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">大家</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">1104 </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 size="2"><span style="mso-spacerun: yes;">&nbsp;</span>=ROUNDDOWN(C3,-2)</font></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 size="2"><span style="mso-spacerun: yes;">&nbsp;</span>=IF((C3-D3)&gt;39,50,0)</font></font></td><td class="xl29" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2"><span style="mso-spacerun: yes;"><font face="Times New Roman">&nbsp;</font></span><font class="font6" face="宋体">=IF((C3-D3-E3)&gt;39,50,0)</font></font></td><td class="xl29" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2"><span style="mso-spacerun: yes;"><font face="Times New Roman">&nbsp;</font></span><font class="font6" face="宋体">=C3+D3+E3</font></font></td><td class="xl30" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2"><span style="mso-spacerun: yes;"><font face="Times New Roman">&nbsp;</font></span><font class="font6" face="宋体">=B3-F3</font></font></td></tr></tbody></table>

[此贴子已经被作者于2007-1-3 13:49:50编辑过]