7 Click cell H13 4.000
Insert a PMT function to calculate the payments for students who want to pay for their trips in three installments ( months ). Use the interest rate and months in the input area above the data . Use appropriate relative , mixed , and / or absolute cell references in the formula . Make sure the result is a positive value .
Copy the function down through cell H22 .
8 Click cell I13 4.000
Calculate the agent commission using the base cost of the trip and a VLOOKUP function that returns the commission rate based on the base cost of the trip using the rates lookup table . The function should then calculate the monetary value of the commission .
Copy the function down through cell I22 .