EFFECT Function Explained
The EFFECT function in Microsoft Excel calculates the effective annual interest rate given the nominal interest rate and the number of compounding periods per year. It returns the effective interest rate as a percentage.
EFFECT Function Syntax
EFFECT(nominal_rate, npery)
- nominal_rate: The nominal interest rate per period.
- npery: The number of compounding periods per year.