FriendsEAT New York

FriendsEat

Category

How do you use the EFFECT function in MS Excel?


In Microsoft Excel how do you use the function EFFECT?

In: Technology | 548 days ago

Alternative Question

No similar questions found.

Click here to create your own alternative question

Answers (1)


         EFFECT() is a financial function, which returns the effective annual interest rate. Syntax: EFFECT(nominal_rate, npery). "nominal_rate" is the nominal interest rate. "npery" is the number of compounding periods per year. Eg: EFFECT(5.25%,4) returns the effect annual interest rate 5.3543 percent.

244 days ago

RSS Feeds & Links

Popular

Copyright 2009. Binary Bits, LLC.