Google Sheets reference

RATE in Google Sheets

Works in Google Sheets1 worked example

Worked examples (1)

These formulas work in Google Sheets with identical syntax.

Financialadvanced

=RATE(B1*12,-B2,B3)*12

Also in Excel

See the full RATE reference for Excel — including all worked examples, common errors, and FAQ.