Syntax

NOMINAL(effective_rate, periods_per_year)

Arguments

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

  • effective_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 nominal interest rate given the effective rate and number of compounding periods per year.”

Google’s help article for NOMINAL →

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