what is the formula for E13

Marketing Analytics Bonus Data Rating Bonus 0% 5% Survey Score Rating Bonus Monthly Take Home w Onthly alary 4,167 6,271 5,604 3,832 4,896 5,083 in uw Jonathan Weiss E13 Whichever bonus rate in the table above applies to a rating score that is closest to the Survey Score without being above is applied to Monthly Salary to calculate the Rating Bonus (%), which is then multiplied by the Monthly Salary. This formula should be copied across E10-E15. 2/13/2020 12:56 PM Reply ill not te o ri e pro Lockridge Marketing Analytics 6 Inputs and Constants 7 Today: 8 Employees Surveyed 2/24/2020 Bonus Data Rating 6 Bonus Survey Score Rating Bonus Monthly Take Home Survey Code Annual Salary 38078 $ 50,000 41105 $ 75,250 39752 $ 67,250 37872 $ 45,980 40616 $ 58,750 40347 $ 61,000 Monthly Salary $ $ $ 5,604 $ $ 4,167 6,271 3.5 3,832 Statistics 22 Lowest Bonus 23 Average Bonus 24 Highest Bonus NOTE: FROM PROFESSOR - These cells will not turn gree 25