use formula in excel

determine the mortgage rate to be applied to each client based on their credit score using v lookup function in excel

You will need to create a V-Lookup Table using this information. Set up table in the space provided on the worksheet. Lookup Table data 850+ 2.50% 800-849 2.75% 750-799 3.00% 700-749 3.25% 650-699 3.50% 600-649 3.75% 550-599 4.00% 500-549 4.25% 450-499 4.50%6 400-449 4.75% 350-399 5.00% 300-349 5.25% 0-299 5.50% Determine the Mortgage Rate to be applied to each client based on their Credit Score using the V-Lookup function. Format the rate to the percentage format with 2 digits to the right of the decimal. Save the file and submit assignment through the drop box. *For help, see pages 178-179 of your text and the videos provided in this module