Hello. (Sorry if anything gets bad written, as I'm Portuguese)
I'm fairly new to Excel VBA programing, and I need some help.
I'm currently trying to build one spreadsheet on excel to evaluate my work schedule, to calculate the amount of money that I should receive on the end of month.
I have achieved almost all I want, but now I have hit a wall.
On one previous version, I had used only excel and got the spreadsheet to work using very very nested IF clauses. Now I want to do something more elaborate and decided to code in VBA in excel.
My problem is that to the monthly income I received, I have to take a percentage for IRS discounts.
I have a table in a spreadsheet (attached), from which I need to extract the percentage for IRS discounts. That percentage is related to the monthly remuneration and the number of children).
I have tried using index and match, but I'm not able to select the values from the table.
For example, lets say I received this month 1010€ and I have no children. Acording to that attached table de discount percentage should be 12,1%
How can I program a routine in excel vba to feed those numbers and the program select the apropriate value from the table?
Many many thanks,
Amílcar Bastos