hope u can help me with this one.

here's the witholding tax table:
0.00 0.00 *20.83 * 104.17
STATUS ('000P) +0% over *+5% over * +10% over
A. Table for employees without dependent children
S 20.00 1.00 *833.00 * 1,250.00
HF 25.00 1.00 1,042.00 1,458.00
ME 32.00 1.00 1,333.00 1,750.00

B. Table for head of family with dependent child(ren)
HF1 33.00 1.00 1,375.00 1,792.00
HF2 41.00 1.00 1,708.00 2,125.00
HF3 49.00 1.00 2,042.00 2,458.00
HF4 57.00 1.00 2,375.00 2,792.00

B. Table for married employee with dependent child(ren)
1 ME1 40.00 1.00 1,667.00 2,083.00
2 ME2 48.00 1.00 2,000.00 2,417.00
3 ME3 50.00 1.00 2,333.00 2,750.00
4 ME4 64.00 1.00 2,667.00 3,083.00


meaning: S (single), HF(head of the family), HF1(head of the family
with 1 dependent), ME(married), or ME1(Married with 1 dependent), etc.

***Now here's the case:
if an employee is (S) single and his gross salary is 900
computation: (900 - 833.00) *.05+ 20.83 (the one which font is bold)

it's very complicated since status(S,HF,ME etc) needs to consider
first. then next is the salary which is the basis for tax computation,
where it should be deducted to it's lesser value indicated in the
table.

thanks!


--
si_ako
------------------------------------------------------------------------
si_ako's Profile: http://www.excelforum.com/member.php...o&userid=35078
View this thread: http://www.excelforum.com/showthread...hreadid=552693