use IF FUNCTION to complete the exercise,

I need help completing this exercise, please. Thank you in advance!

Financing Calculator Loan Down AmountTerm Interest Monthly Credit Score Car Vehicle Price Payment Financed (Months)Rate Payment Financing Table Customer Required Down Ann Payment Interest PercentRate (months) Loan Term 718 722 638 653 664 730 688 740 $8,500 $14,200 $12,800 $21,700 $6,200 $6,700 $7,800 $12,300 Credit Score Alice Allgood Brad Beamer Carlos Cortez Delilah Dantle Edith Esperanza Fred Friendl Gilda Goshawk Harold Hecuba Honda Civic Buick LeSabre Pontiac Vibe Dodge Caravan Nissan Versa Ford Focus Chevrolet Cobalt Buick Skylark 36 Any other credit score | 20% | 6.50% | 42 Between 599 and 701 30% | 8.00%