[求助]哪位好心人帮忙做个个人所得税倒算工资表！

shndwf

<p>已知个人所得税额，以及养老金、公积金、医保，费用扣除标准为1600，求实际发生的工资总额。</p><p>请会做公式的老师给帮忙编一下，谢谢！谢谢！！！</p>

shndwf

<p><a href="http://club.excelhome.net/viewthread.php?tid=86640">http://club.excelhome.net/viewthread.php?tid=86640</a></p><div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>风中灵</i>在2005-3-15 11:16:00的发言：</b><br/><p>例如：年终奖为24000元，则应计个人所得税为：24000*10%-25=2375元。</p><p>月度个税顺算公式：设月度工资为X,则有：MAX(IF(X-800&gt;{0,500,2000,5000,20000,40000,60000,80000,100000},{0,25,175,625,3625,8625,14625,21625,29625}+(X-800-{0,500,2000,5000,20000,40000,60000,80000,100000})*{0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45},0))。月度个税逆算公式：MIN(IF(X&gt;={0,25,175,625,3625,8625,14625,21625,29625},(X-{0,25,175,625,3625,8625,14625,21625,29625})/{0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45}+{0,500,2000,5000,20000,40000,60000,80000,100000},9E+99))+800</p><p>年终奖顺算公式：设年终奖为X，则有：=MAX(IF(X/12&gt;{0,500,2000,5000,20000,40000,60000,80000,100000},{0,25,175,625,3625,8625,14625,21625,29625}+(X-{0,500,2000,5000,20000,40000,60000,80000,100000})*{0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45},0))</p><p>但是：年终奖逆算的公式在哪里？？？？</p><p></p></div>