need help with these last few questions please
Depending on the city, you will either take a shuttle to/from the airport or rent a car. Your next task is to enter the cost of the shuttle or rental car in the dataset using a logical function. Click cell E14. Insert an IF function that compares to see if Yes or No is located in the Rental Car? column for a city. If the cell contains No, display the shuttle value in cell F2. If the cell contains Yes, display the value in the Rental Car Total (cell F4). Copy the function from cell E14. Use the Paste Formulas option to copy the function to the range E15:E19 without removing the border in cell E19. Next, you will enter a formula to calculate the lodging. The lodging is based on a multiplier by City Type. Some cities are more expensive than others. You coded cities 1,2,3, or 4 and a percentage of cost. Click cell F14. Insert a VLOOKUP function that looks up the City Type (cell B14), compares it to the City/COL range (A8:B11), and returns the COL percentage. Then multiply the result of the lookup function by the Total Base Lodging (cell B6) to get the estimated lodging for the first city. Copy the function from cell F14 and use the Paste Formulas option to copy the function to the range F15:F19 without removing the border in cell F19. You are now ready to calculate the total expenses for each city. Click cell H14 and enter the function that calculates the total costs for the first city, including airfare, shuttle or rental, lodging, and meals. Copy the function in cell H14 and use the Paste Formulas option to copy the function to the range H15:H19 without removing the border in cell H19. Queries & Connections Data Types Sort \& Filter fx C G J Highest \begin{tabular}{|l|l|} \hline Lookup & Total \\ Washington DC & \\ \hline \end{tabular} \begin{tabular}{|lr|} \hline APR & 3% \\ \hline Months & 12 \\ \hline \end{tabular}