Conditional Bonus Calculator
Turn a written bonus policy into one formula: a tiered rate by target attainment, a tenure add-on, a cap and a rating that can cancel the bonus.
What you will practise: Translate a multi-condition policy into a formula that combines IFS or nested IF with an add-on, a cap and an override, and that is right exactly on the boundaries.
Premium
This is a Premium exercise
Premium members can open this exercise and practise it in the spreadsheet.