Click cell E$14.$ 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 F$2.$ If the cell contains Yes, display the value in the Rental Car Total $($cell F$4).$ Use relative and mixed $($or absolute$)$ references correctly. Copy the function from cell E$14.$ Use the Paste Formulas option to copy the function to the range E$15$:E$19$ without removing the border in cell E$19.$