EFFECT function
Summary
Returns the effective annual interest rate
Syntax
EFFECT(nominal_rate, npery)
The EFFECT function syntax has the following arguments:
• Nominal_rate Required. The nominal interest rate.
• Npery Required. The number of compounding periods per year.
• Nominal_rate Required. The nominal interest rate.
• Npery Required. The number of compounding periods per year.
Example
=EFFECT(A2,A3)