## EFFECT function: Description, Usage, Syntax, Examples and Explanation

What is EFFECT function in Excel? EFFECT function is one of the Financial functions in Microsoft Excel that returns the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year. Syntax ofÂ EFFECT function EFFECT(nominal_rate, npery) The EFFECT function syntax has the following arguments: Nominal_rate: The nominal interest …