The RATE function in Excel is a financial function that returns the annuity's interest rate each period. RATE can be used to get the periodic interest rate, which can then be multiplied to get the annual interest rate. Iteration is used to calculate the RATE function. nper - The number of payment periods in total.