The EFFECT() function calculates the effective yield for a nominal interest rate (annual rate or APR). For example: 8% interest compounded monthly provides an effective yield of EFFECT(.08; 12) or 8.3%.
La funkcio effective () kalkulas la efektivan rezulton por nominala interezo Ekzemple: 8% da interezo monate kalkulata donas efektivan interezon de effective( 0, 08; 12) =8. 3%.