In cell F4, enter a Lookup function to display the interest rate of the loan. The function
Fantastic news! We've Found the answer you've been seeking!
Question:
In cell F4, enter a Lookup function to display the interest rate of the loan. The function should reference the borrower?s credit rating and the table array in range A15:C18. Include the range_lookup argument to ensure an exact match.
In cell F5, insert a lookup function that uses the credit rating to determine the minimum down payment based on the table array A15:C18. Include the range_lookup argument to ensure an exact match. Multiply the function result by the negotiated cost of the vehicle. |
Related Book For
Finance Applications and Theory
ISBN: 978-0077861681
3rd edition
Authors: Marcia Cornett, Troy Adair
Posted Date: