Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: EFFECT function

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 rate. Npery: The number of…