Please help.
I have a tax table here where in tax deduction and percentage depends on tax status and monthly salary. Please help me come up with a formula that would be able to get the Deduction and percentage based on status and salary given.
Hlookup will not work for approximate value
salary must be greater than the largest deduction value
in the example given, 32000 falls under column G or column 7 (25000)
please see attached file.
Bookmarks