Please write an Excel formula that works for this.

number between the rates given in the table. For example, suppose you borrow money for 15 years. Because 15 years is one-quarter of the way betwer 10 . years and 30 years, the annual loan rate would be calculated as follows: .75.09+.25.10. Write a formula that returns the annual interest rate on a loan for any number between the rates given in the table. For example, suppose you borrow money for 15 years. Because 15 years is one-quarter of the way betwer 10 . years and 30 years, the annual loan rate would be calculated as follows: .75.09+.25.10. Write a formula that returns the annual interest rate on a loan for any