what formula should i put in E13

dge Marketing Analytics Bonus Data 020 Rating Bonus Survey Score Rating Bonus Monthly Take Home JW Monthly Salary 000 $ 4,167 250 $ 6,271 5,604 980 3,832 750 $ 4,896 000 $ 5,083 250 $ 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... rill not turn ake Home 2 Lockridge Marketing Analytics Bonus Data 6 Inputs and Constants 7 Today: 8 Employees Surveyed 2/24/2020 Rating Bonus enthly Survey Rating Bonus Take Home Survey Score Monthly Annual Survey Code Monthly Salary Salary 38078 $ 50,000 $ 4,167 41105 $ 75,250 $ 6,271 39752 $ 67,250 $ 5,604 37872 $ 45,980S 3,832 40616 $ 58,750 $ 4,896 40347 $ 61,000 $ 5,083 NOTE: FROM PROFESSOR - These cell Statistics 22 Lowest Bonus 23 Average Bonus 24 Highest Bonus