I have a problem. The problem is that we know the cost to company and we are trying to calculate medical aid contributions and basic salary. Would've been easy if the contribution was a fixed amount. Problem is that the contribution is on a sliding scale and there are different plans.
Is there a way to solve this in Excel with just plain maths or formulas?
The calculation would look like follows:
Basic Salary x Medical Aid (based on x) y Cost to Company x+y
And then medical aid extract:
If medical aid option 1 is taken:
x < 1000 y = 20 1001 < x < 2000 y = 25 2001 < x y = 30
If medical aid option 2 is taken:
x < 750 y = 18 751 < x < 1800 y = 23 1801 < x y = 25
Bookmarks