Hi Excel Geni
I am trying to calculate the Annual Estimate by multiplying the Grade 'percentage equivalent' by the Annual Amount using the equivalent Grade amount quoted in a small table within the spreadsheet. Any ideas please? Thank you!
<tbody>
</tbody><colgroup><col><col><col><col><col><col></colgroup>
I am trying to calculate the Annual Estimate by multiplying the Grade 'percentage equivalent' by the Annual Amount using the equivalent Grade amount quoted in a small table within the spreadsheet. Any ideas please? Thank you!
Grade | Bonus Rate | ||||
1 | 10% | ||||
2 | 10% | ||||
3 | 15% | ||||
4 | 20% | ||||
5 | 20% | ||||
6 | 25% | ||||
7 | 27% | ||||
8 | 30% | ||||
Monthly amount | Grade | Status | Start Date | Annual Amount | Annual Estimate |
5000 | 8 | Current | 01/05/2013 | 60,000.00 | 6,000 |
6000 | 8 | Current | 72,000.00 | 7,200 | |
3000 | 7 | Current | 36,000.00 | 3,600 | |
2500 | 7 | Current | 30,000.00 | 3,000 |
<tbody>
</tbody><colgroup><col><col><col><col><col><col></colgroup>