What is RATE called in Spanish?

In Spanish Google Sheets it is TASA. The formula =RATE(B2,-B3,B1) is written =TASA(B2;-B3;B1) (or with commas under a Mexico locale).

Why does RATE use semicolons in some spreadsheets?

It depends on each spreadsheet's locale, under File > Settings. Where the comma is the decimal mark (Spain, much of South America), arguments are separated by semicolons. Mexico and United States locales use commas.

Google Sheets RATE function

Returns the interest rate per period of a loan or installment purchase. In Spanish Sheets it is called TASA.

Syntax

English Sheets

=RATE(number_of_periods, payment_per_period, present_value)

Spanish Sheets (Mexico locale)

=TASA(número_de_períodos, pago_por_período, valor_actual)

Spanish Sheets (Spain, Latin America)

=TASA(número_de_períodos; pago_por_período; valor_actual)

Argument	What it is
number_of_periods	How many payments.
payment_per_period	The payment, as a negative.
present_value	The amount you receive.

Example

"12 payments of 1150" sounds fine, but what interest are you paying? RATE(number_of_periods, payment_per_period, present_value) returns the rate per period. Multiply it by 12 for the annual rate.

=RATE(B2,-B3,B1)

Common mistake

With monthly payments the result is monthly: multiply by 12 for the annual rate. Matching signs give #NUM!.

About Ads

This site uses Google AdSense to display ads. These ads help us keep WebHerramientas completely free. Ads are managed by Google and meet strict security and privacy standards.

Practice RATE

Type the formula in the sheet and check it instantly. Spanish or English function names both work. See all lessons

Your progress0/103

My spreadsheet is inGoogle Sheets functions in English and Spanish

The real rate with RATE

"12 payments of 1150" sounds fine, but what interest are you paying? RATE(number_of_periods, payment_per_period, present_value) returns the rate per period. Multiply it by 12 for the annual rate.

Example=RATE(B2,-B3,B1)TASA = RATE

Also try Loan Calculator

Step 1/2

In B5, calculate the monthly interest rate of the installment purchase.

	A	B
1	Cash price	12000
2	Number of payments	12
3	Monthly payment	1150
4
5	Monthly rate
6	Annual rate
7

Tip: while typing, click a cell or drag across several to insert their reference.

Frequently asked questions

What is RATE called in Spanish?: In Spanish Google Sheets it is TASA. The formula =RATE(B2,-B3,B1) is written =TASA(B2;-B3;B1) (or with commas under a Mexico locale).
Why does RATE use semicolons in some spreadsheets?: It depends on each spreadsheet's locale, under File > Settings. Where the comma is the decimal mark (Spain, much of South America), arguments are separated by semicolons. Mexico and United States locales use commas.
What is the most common RATE mistake?: With monthly payments the result is monthly: multiply by 12 for the annual rate. Matching signs give #NUM!.