Explainry Tutorials to Expert in IT

EFFECT function in Excel


The EFFECT function calculates an effective annual interest rate for a loan or an investment if the compounding periods per year along with the nominal interest rate are given. The function is one of the Financial functions,  often used to make the comparison between loans with different compounding periods.


EFFECT(nominal_rate, npery)

The EFFECT function has the followings arguments:

nominal_rate – The nominal interest rate per year.

npery – The number of compounding periods per year.



To change the result format into a percentage, press Alt, H then P.

For more detail and examples on the EFFECT function, visit Microsoft Office Website.

Function Errors

Error Occurs
#VALUE! If any supplied argument is nonnumeric.
#NUM! If nominal_rate ≤ 0 or if npery < 1

Related Function

NOMINAL function calculates the nominal interest rate of a bond having an effective interest rate and compounding periods per year.

Copyright © 2016 - 2020 Explainry.com | All Rights Reserved