how do I do this?

14. Determine which vehicles are affordable. a. In cell C26, enter a formula using the IF function to display "yes" if the total monthly cost (cell C24) is less than or equal to the total monthly amount available for vehicle expenses (Data sheet, cell A4). Display "no" if the total monthly cost is not less than or equal to the total monthly amount available. b. Copy the formula to the appropriate cells for the other vehicles. c. Display formulas and use the error checking skills learned in this lesson to track down and fix any errors. H A B c D E F 1 Vehicle Purchase Assumptions 2 3 $9,000 Total Cash Available for Vehicle Purchase 4 $650 Total Monthly Amount Available to pay for Operating Vehicle 5 650 Number of Miles | Expect To Drive Each Month 6 $2.79 Gas Price Per Gallon 7 6 00 9 Registration Fee Lookup Table 2 10 column # 11 12 13 14 15 16 17 1 Cargo Van Farm Vehicle Motor Home Motorcycle Passenger Trailer Truck 100 68 100 60 100 30 1001 AutoSave Trevor Bottom-EX2019-Chalenge Yourself-3-3(2) - Excel o Trevor Bottom File Home Insert Draw Page Layout Formulas Data Review View Help Share CIS f If D Analysis Vehicle 2 Vehicle 3 Vehicle 4 1 Vehicle Purchase Vehkle 1 Description 2019 Ford Mustang Convertib Vehicle Type Passenger 2019 Ford F150 Truck 2017 Toyota Prius Passenger 2017 Ducati Super Sport Motorcycle Averara Lowest dealer $31,895 21 dealer $26.115 19 25 22 private seller $24.463 58 53 555 private seller $12,995 36 36 96 Price MPG City MPG Highway 26 Average MPG $600 100 $1,200 $500 100 $800 $300 100 $900 $500 60 $1,500 Maintenance/Yearl Registration Feel Insurance/Year NPR 1.90 Seller 7 Price UPG CITY 9 MPG Highway 10 Averape MPG 11 Yearly Costs 12 Maintenance/Year Registration fee Insurance/Year 15 Need Loan? 16 Amount to Borrow 17 Years 19 Monthly Costs 20 Loan Payment 21 Gas 22 Maintenance/Month 23 Insurance/Month 24 Total Monthly 25 Affordable? 27 28 29 30 3.203 5 2 90% 3 5.90 Amount to Borrow APA Years 3 2 Loan Payment Gas Maintenance/Month Insurance/Month Total Monthly