Hey People,
I am working on developing a worksheet that will calculate employee tax payable to the Revenue authority. The income tax relief in Kenya is Kes 1,162. The below formula works well, but I would like to add a final line to this formula that states. "If the income tax calculated by the below formula is less than or equal to Kes 1,162, the result should be a zero. Please help.
=IF(AND($I11<'Tax Table'!$A$4,$I11=0),0,IF(AND($I11>='Tax Table'!$A$4,$I11<='Tax Table'!$B$4),'Tax Table'!$C$4*Payroll!$I11,IF(AND($I11>='Tax Table'!$A$5,$I11<='Tax Table'!$B$5),'Tax Table'!$C$5*($I11-'Tax Table'!$G$4)+'Tax Table'!$E$4,IF(AND($I11>='Tax Table'!$A$6,$I11<='Tax Table'!$B$6),'Tax Table'!$C$6*($I11-'Tax Table'!$G$5)+'Tax Table'!$E$5,IF(AND($I11>='Tax Table'!$A$7,$I11<='Tax Table'!$B$7),'Tax Table'!$C$7*($I11-'Tax Table'!$G$6)+'Tax Table'!$E$6,IF(AND($I11>'Tax Table'!$A$8),'Tax Table'!$C$8*($I11-'Tax Table'!$G$7)+'Tax Table'!$E$7,"Something Wrong"))))))
Bookmarks