you must build a conditional formula using IF functions. The bonus should be shown as currency format according to the following conditions: If the employees performance rating is 5, use the percentage associated with Bonus 1 to calculate the bonus. If the performance rating is 3 or 4, bonuses should be calculated based on the percentage associated with Bonus 2. Otherwise, bonuses should be calculated based on the percentage associated with Bonus 3