EFFECT

The EFFECT function in Excel is a financial function that returns the effective annual interest rate, using the nominal interest rate (APR) and the number of compounding periods per year. The effective annual interest rate is the actual interest rate earned due to compounding.