EFFECT(rate,nper)
rate: nominal annual interest rate
nper: number of periods used for compounding
EFFECT calculates the effective interest rate using the formula (1+rate/nper)^nper-1.
NOMINAL.