To calculate the Bonuses for January (row 17), you will use the IF function to c

Question

To calculate the Bonuses for January (row 17), you will use the IF function to compare the January

Sales (B7) to the Target for Bonus amount (B29) under Assumptions.
If the January Sales meets or exceeds the Target, then they will get a % of the sales as indicated

January 1, 2017 to December 31, 2017 Today's Date: January February March May September ctober November December Total 32099 892 36198 991 23894 35001 801 38645 901 45690 44321 890 29411 38382 964 25401 31895 40938 Interest 795 1021 Total Income 29239 32991 37189 35802 46578 45211 24870 39546 30310 39346 26343 32916 42034 5688.8 4266.6 2844.4 4266.6 2844.4 6419.8 4814.85 3209.9 4814.85 3209.9 7239.6 5429.7 3619.8 5429.7 3619.8 7000.2 5250.15 3500.1 5250.15 3500.1 9138 6853.5 4569 6853.5 4569 8864.2 6648.15 4432.1 6648.15 4432.1 4778.8 3584.1 2389.4 3584.1 2389.4 5796.75 3864.5 5796.75 3854.5 5882.2 4411.65 2941.1 4411.65 2941.1 7676.4 5757.3 3838.2 5757.3 3838.2 5080.2 3810.15 2540.1 3810.15 2540.1 6379 4784.25 3189.5 4784.25 3189.5 81876.2 61407.15 40938.1 61407.15 40938.1 Sales Force Rent & Utilities Bonuses Total Expenses Assumptions Product Administrative Sales Foroe Rent & Utilities 20% 15% 10% 15% 10% $35,000 Target for Bonus Bonus %

Explanation / Answer

if the bonus is given on the amount above the sales target

= (IF((B17>35000),(B17-35000)*0.01,0))

if the bonus is given on the whole amount

= (IF((B17>35000),(B17)*0.01,0))

generally case 1 holds

now you can apply this formula in same row by stretch on the corner of B30 taking to the right till wherever you want the formula to be applied

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.