Google sheets financial EFFECT Google Sheets function Written by Data Empower May 18, 2025 Determines the annual effective interest rate based on the nominal rate and the frequency of compounding periods each year.