On the Cities worksheet, click cell E$13.$ Depending on the city, you will either take a shuttle to$/$from the airport or rent a car. Insert an IF function that compares to see if Yes or No is located in the Rental Car? Column for a city. If the city contains No$,$ display the value in cell F$2.$ If the city contains Yes, display the value in the Rental Car Total $($F$4).$ Copy the function from cell E$13$ and use the Paste Formulas option to copy the function to the range E$14$:E$18$ without removing the border in cell E$18.$