Syntax

EFFECT(nominal_rate, periods_per_year)

Arguments

The printed syntax lists 2 argument(s), in order:

  • nominal_rate
  • periods_per_year

“optional” marks an argument Google prints in square brackets; “repeatable” marks one Google prints with “…”.

Description from Google Docs Editors Help

“Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year.”

Google’s help article for EFFECT →

Source: Google Docs Editors Help, “Google Sheets function list” (support.google.com/docs/table/25273), record record 95 of 516, data fetched 28 September 2026. Data month: September 2026.