Open CaseStudy1.xlsx. 2. Click cell B5. Using the correct function, provide a Count of the number of agents. Use the Agent ID cell range to Count the number of agents. 3. Click on F10. 4. The next step is to figure out the amount of bonus for each sales agent. To do this, you need to know the number of years of service which is shown in the range of cells from B10 to B16. Plus, you will see that that sales values and bonus values are found in the range of E5:G7. Below are some hints to help you create this formula: You will have to use an IF function and nest in it with a XLOOKUP statement for both the true value and false values. Remember that the syntax for the IF function is: =IF(logical_test,[value_if_true],[value_if_false]) (IF Website Help) Start with the IF function and make sure the logical test is comparing the Years of Service. The logical test should look at the values in C10:C16 and see if it is less than the value in C6. NOTE - Make sure to you use the correct referencing on Cell C6 because you will be filling down the formula. You will use the XLOOKUP function for the true and false values. Remember that syntax of XLOOKUP is: =XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) For the True Value for the IF statement, use XLOOKUP: The lookup value will the total sales generated: E10. The lookup array will be the sales values within the bonus table: E5:E7. NOTE - Make sure to you use the correct referencing