I maintain an Excel Spreadsheet to calculate the Gross pay, Statutory contributions and employees tax deductions. Our Tax Table is as follows :
GP = Gross Pay
TA = Tax Amount to be deducted
IF GP < $21,748, TA=0
IF GP >$21,748 < 26,042,TA = 9.2% of GP-2000
IF GP >26,042 < 37083, TA = 10% of GP-$2208
IF GP >37083 < 52083, TA = 20% of GP-$5917
IF GP > 52083, TA = 35% of GP-$13729
Our Salaries are calculated on the number of Work days in the month and multiplied by the Exchange Rate prevalent on the date of payment and as such the TA amount differs from one month to the other. what I want EXCEL to do is that when a GP shows up on one Cell for one individual , the TA amount should be automatically displayed in the other cell.
Thanks
Rushdhi
GP = Gross Pay
TA = Tax Amount to be deducted
IF GP < $21,748, TA=0
IF GP >$21,748 < 26,042,TA = 9.2% of GP-2000
IF GP >26,042 < 37083, TA = 10% of GP-$2208
IF GP >37083 < 52083, TA = 20% of GP-$5917
IF GP > 52083, TA = 35% of GP-$13729
Our Salaries are calculated on the number of Work days in the month and multiplied by the Exchange Rate prevalent on the date of payment and as such the TA amount differs from one month to the other. what I want EXCEL to do is that when a GP shows up on one Cell for one individual , the TA amount should be automatically displayed in the other cell.
Thanks
Rushdhi