Forum Discussion
Solved
Search correspondance and calculate
Hi members, I have a table where I list the tax value for a slice of salary: Min. Max. Tax 0 30000 0% 30001 50000 10% 50001 60000 20% 60001 80000 30% 80001 180000 3...
spamitovic Please see attached. I used LOOKUP rather than VLOOKUP. If you are on a modern Excel version, consider XLOOKUP.
By the way, I believe a monthly salary of 2500 (i.e. 30000/year) should result in 0%, in stead of 10% in your example.
spamitovic Please see attached. I used LOOKUP rather than VLOOKUP. If you are on a modern Excel version, consider XLOOKUP.
By the way, I believe a monthly salary of 2500 (i.e. 30000/year) should result in 0%, in stead of 10% in your example.
Best answer. Thank you.
Yes a monthly salary of 2500 should result in 0%.
Yes a monthly salary of 2500 should result in 0%.