Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year.
81% OFF online library of tutorials for mastering Google Sheets
EFFECT()
Description
How To Use in Sheets
EFFECT(nominal_rate, periods_per_year)
External Links
Google Sheets EFFECT Function | Calculate the Effective Interest Rate | How to Use EFFECT function
With the Google Sheets EFFECT function, you can calculate the effective interest rate for an investment or a loan. The nominal interest rate does not give you the actual return on an investment like the fixed deposit or from a savings account. In contrast, the effective interest rate gives you the actual return.
0Better Sheets Tutorials
No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.