=IF(AND(D16>=$A$9,D16<$A$10),$C$9,IF(AND(D16>=$A$10,D16<$A$11),$C$10,IF(AND(D16>=$A$11,D16<$A$12),$C$11,IF(D16>=A12,$C$12,"N/A")))) RATE(nper,pmt,pv,fv,type)—Solves for the interest rate per period

NPER(rate,pmt,pv,fv,type)—Solves for the number of periods

PMT(rate,nper,pv,fv,type)—Solves for the value of the payment per period

PV(rate,nper,pmt,fv,type)—Solves for the initial value, the amount in or out at the beginning of the financial transaction

FV(rate,nper,pmt,pv,type)—Solves for the final value, the amount in or out at the end of the financial transaction ;