PAYE Payroll Calculation for Nigeria using Formula

[Chibuzor_Derrick]

@flexy2ky

Almost there but missing something in condition. To determine the band your condition from Tax Payable 2 upwards must identify the tax bracket otherwise it will calculate payable tax wrongly. so for instance:

Tax Payable 2 Condition: (first N300,000)
CI > 0 and CI <= 300000

Tax Payable 3 Condition: (Next N300,000)
CI > 300000 and TI <= 600000

Tax Payable 4 Condition: (Next N500,000)
CI > 600000 and CI <= 1100000

and so on until you get to Tax Payable 7 which determines the tax payable if next salary band is is in excess of N3,200,000.

inserted the conditions but didnt get any deduction on the slip