Forum Discussion
Solved
Match Index Function
Good day I'm facing a dilemma with my Excel spreadsheet, and I hope you can help. I've attached a sample spreadsheet for reference. The key sheets are: 2024_2025 Tax Table: This sheet conta...
See the attached demo workbook. It uses formulas only.
Calculation:
• Tax on income up to R205,900 = R205,900 * 0.18 = R37,062
• Tax on income between R205,901 and R321,600 = (R321,600 - R205,900) * 0.26 = R33,324
• Tax on income between R321,601 and R445,100 = (R445,100 - R321,600) * 0.31 = R40,840
• Tax on income between R445,101 and R500,000 = (R500,000 - R445,100) * 0.36 = R19,260
• Total tax paid = R37,062 + R33,324 + R40,840 + R19,260 = R130,486
With the exception of the first calculation I get different results. Please check.
Currently, I designed the calculations separately as I don't think Excel might be able to look at the variables without involving VBA for example.
See the attached demo workbook. It uses formulas only.
- This worked perfectly. Thank you