To calculate the Bonuses for January {row 17), you will use the IF tunction to compare the January Sales {BY} to the Target for Bonus amount (329) under Assumptions. 0 If the January Sales meets or exceeds the Target, then they will get a % of the sales as indicated under Assumptions (multiply the 96 for Bonuses (330] by the Sales (B7)}. If they don't meet the sales amount, then they get $0. Use Absolute and Relative Referencing. Note: It is possible folr some of these results to be $0