Post by MS INYOFU (@theconscience)

HINT – Automatic PAYE Formula (New Tax Law)

Example assumes no Pension (8%), NHF (2.5%), or NHIS (5%) deductions.

If Taxable Income is in G8, enter this formula in H8:

=IF(G8<=800000,0,IF(G8<=3000000,(G8-800000)*0.15,IF(G8<=12000000,330000+(G8-3000000)*0.18,IF(G8<=25000000,1950000+(G8-12000000)*0.21,IF(G8<=50000000,4680000+(G8-25000000)*0.23,10430000+(G8-50000000)*0.25)))))

Explanation:
The formula automatically applies the correct 0%–25% PAYE tax bands based on taxable income.

HINT – Automatic PAYE Formula (New Tax Law) Example assumes no Pension (8%), NHF (2.5%), or NHIS (5...

0 likes · 0 comments · 0 shares