The ►Eff( command converts from a nominal interest rate to an effective interest rate. In other words, it converts an interest rate that does not take into account compounding periods into one that does. The two arguments are 1) the interest rate and 2) the number of compounding periods.
For example, take an interest rate of 7.5% per year, compounded monthly. You can use ►Eff( to find out the actual percent of interest per year:
The formula for converting from a nominal rate to an effective rate is:
Here, Eff is the effective rate, Nom is the nominal rate, and CP is the number of compounding periods.
- ERR:DOMAIN is thrown if the number of compounding periods is not positive, or if the nominal rate is -100% or lower (an exception's made for the nominal rate if there is only one compounding period, since ►Eff(X,1)=X)