EDIT: Title should read 'Need formula to derive gross salary from net salary, using bracketed/tiered tax deduc. table (tax deduction table)
Hi all,
With reference to the attached.
I am looking for a formula to write in cell D4, that will be capable of taking the the 'net' salary in cell D3 and calculating what the gross salary should be, by calculating what the salary tax deductions are by using the tax brackets in the table below (cells B6 - H12).
In columns L - Q I have inserted an example of how the salary tax brackets work, to assist members on here to understand better.
Thanks in advance
Bookmarks