Taxable Income = Income - (Pension + Home ownership + NSSF)
To calculate your TAX in Excel, copy paste the below and replace "Taxable income":
(IF((Taxable income)>10164,10164*10%,0))+(IF(((Taxable income)-10164)>0,IF(((Taxable income)-10164)>9576,9576*15%,((Taxable income)-10164)*15%),0))+(IF(((Taxable income)-10164-9576)>0,IF(((Taxable income)-10164-9576)>9576,9576*20%,((Taxable income)-10164-9576)*20%),0))+(IF(((Taxable income)-10164-9576-9576)>0,IF(((Taxable income)-10164-9576-9576)>9576,9576*25%,((Taxable income)-10164-9576-9576)*25%),0))+(IF(((Taxable income)-10164-9576-9576-9576)>0,((Taxable income)-10164-9576-9576-9576)*30%,0))