Please help me solve this probelm for "shuttle or rental." My proffesor switched uo the numbers from the probelm online and I dotm understabd it. This is using the IF statement.

OM Formulas ButoSave Scott Exp 19_Excel AppCapstone_IntroAssessment Travel. le Home Insert Formulas Page Layout Data Review View Acrobat Help Logical Define Name - eace Precedents Recently Used - Test Usein Formula Trace Dependents Name Insert unction Financial Date & Time Manager Create from Selection Remove Arrows - Function Library Defined Names Formula Al fx Autosum - X G D E Ground Transportation Round-trip Shuttle Rental Car per Day $ Rental Car Total S 50 35 (175) H Summary Trip Average Lowest Highest Total Cost 1 Departure Date 6/17/2021 2 Return Date 6/22/2021 3 4 Lodging Base/Night $ 125 5 Total Base Lodging $ 625 6 City COL 7 1 95% 8 2 110% 9 3 125% 10 140% 11 Rental 12 Destination City City Type Car? 13 Boston 3 NO 14 Miami 2 Yes 15 Orlando 1 Yes 16 Philadelphia 3 NO 17 San Antonio 1 Yes 18 Washington DC 4 NO 19 20 21 22 23 24 25 26 Lodging Shuttle or Airfare Rental $ 367 392 299 479 218 Meals $ 375 330 285 375 285 420 29 30 21 On the Cities worksheet, click cell E13. 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 F2. If the city contains Yes, display the value in the Rental Car Total (F4). Copy the function from cell E13 and use the Paste Formulas option to copy the function to the range E14 E18 without removing the border in cell E18. 6 22 On the Cities worksheet, click cell F13. The lodging is based on a multiplier by City Type. Some cities are more expensive than others. Insert a VLOOKUP function that looks up the City Type (B13), compares it to the City/COL range (A7:B10), and returns the COL percentage. Then multiply the result of the lookup function by the Total Base Lodging (B5) to get the estimated lodging for the first city. Copy the function from cell F13 and use the Paste Formulas option to copy the function to the range F14:F18 without removing the border in cell F18 6 23 On the Cities worksheet, click cell H13 and enter the function that calculates the total costs for the fust city, including airfare, shuttle or rental, lodging, and meals. Copy the function in cell H13 and use the Paste Formulas option to copy the function to the range H14 H18 without removing the border in cell H18 24 On the Cities worksheet, select the range E14 H18 and apply Comma Style with zero decimal places. Select the range E 13H13 and apply Accounting Number format with zero decimal places 3