O
owen.cxy
Hi, I’m using MS Excel 2007 and nothing else. I have a (column “C†of each
individual’s age) and a (column “J†of each individual’s wage). How do I
calculate the contribution of each individual based on their age and salary?
Below are the criterias.
A) Age: 35 years and below
1) Wage: less than or equal to $50 ïƒ Contribution = $0
2) Wage: more than $50 but less than $500 ïƒ Contribution = 5% of the
difference between (the individual’s wage and $50)
3) Wage: more than $500 ïƒ Contribution = 10% of the individual’s wage up to
the first $500 + 10% of the individual’s additional wage.
E.g. If the wage is $800, Contribution = 0.1*500 + 0.1*300($800-$500)
B) Age: (Above 35 years) to (50 years and below)
1) Wage: less than or equal to $50 ïƒ Contribution = $0
2) Wage: more than $50 but less than $500 ïƒ Contribution = 2% of the
difference between (the individual’s wage and $50)
3) Wage: more than $500 ïƒ Contribution = 5% of the individual’s wage up to
the first $500 + 5% of the individual’s additional wage.
E.g. If the wage is $800, Contribution = 0.02*500 + 0.05*300($800-$500)
C) Age: Above 50 years
1) Wage: less than or equal to $50 ïƒ Contribution = $0
2) Wage: more than $50 but less than $500 ïƒ Contribution = 1% of the
difference between (the individual’s wage and $50)
3) Wage: more than $500 ïƒ Contribution = 2% of the individual’s wage up to
the first $500 + 2% of the individual’s additional wage.
Please help me..Thank you so much
individual’s age) and a (column “J†of each individual’s wage). How do I
calculate the contribution of each individual based on their age and salary?
Below are the criterias.
A) Age: 35 years and below
1) Wage: less than or equal to $50 ïƒ Contribution = $0
2) Wage: more than $50 but less than $500 ïƒ Contribution = 5% of the
difference between (the individual’s wage and $50)
3) Wage: more than $500 ïƒ Contribution = 10% of the individual’s wage up to
the first $500 + 10% of the individual’s additional wage.
E.g. If the wage is $800, Contribution = 0.1*500 + 0.1*300($800-$500)
B) Age: (Above 35 years) to (50 years and below)
1) Wage: less than or equal to $50 ïƒ Contribution = $0
2) Wage: more than $50 but less than $500 ïƒ Contribution = 2% of the
difference between (the individual’s wage and $50)
3) Wage: more than $500 ïƒ Contribution = 5% of the individual’s wage up to
the first $500 + 5% of the individual’s additional wage.
E.g. If the wage is $800, Contribution = 0.02*500 + 0.05*300($800-$500)
C) Age: Above 50 years
1) Wage: less than or equal to $50 ïƒ Contribution = $0
2) Wage: more than $50 but less than $500 ïƒ Contribution = 1% of the
difference between (the individual’s wage and $50)
3) Wage: more than $500 ïƒ Contribution = 2% of the individual’s wage up to
the first $500 + 2% of the individual’s additional wage.
Please help me..Thank you so much