What is RATE called in Spanish?

In Spanish Excel it is TASA. The formula =RATE(B2,-B3,B1) is written =TASA(B2;-B3;B1) (or with commas in Mexico).

Why does RATE use semicolons in some Excel versions?

It depends on regional settings. Where the comma is the decimal mark (Spain, much of South America), Excel separates arguments with semicolons. English Excel and Mexican Spanish Excel use commas.

Excel RATE function

Calculates the interest rate per period of a loan or an installment purchase. In Spanish Excel it is called TASA.

Syntax

English Excel

=RATE(nper, pmt, pv, [fv])

Spanish Excel (Mexico)

=TASA(núm_per, pago, va, [vf])

Spanish Excel (Spain, Latin America)

=TASA(núm_per; pago; va; [vf])

Argument	What it is
nper	The number of payments.
pmt	The payment each period (negative).
pv	The amount received today.
fvoptional	Balance at the end.

Example

"12 payments of 1,150" sounds fine, but what interest are you paying? RATE(periods, payment, amount) returns the rate per period. Multiply it by 12 for the annual rate.

=RATE(B2,-B3,B1)

Common mistake

It returns the rate per period: with monthly payments, multiply by 12 for the annual rate. Payment and amount must have opposite signs.

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/94

My Excel is inExcel functions in English and Spanish

The real rate with RATE

"12 payments of 1,150" sounds fine, but what interest are you paying? RATE(periods, payment, amount) 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	12,000
2	Number of payments	12
3	Monthly payment	1,150
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 Excel it is TASA. The formula =RATE(B2,-B3,B1) is written =TASA(B2;-B3;B1) (or with commas in Mexico).
Why does RATE use semicolons in some Excel versions?: It depends on regional settings. Where the comma is the decimal mark (Spain, much of South America), Excel separates arguments with semicolons. English Excel and Mexican Spanish Excel use commas.
What is the most common RATE mistake?: It returns the rate per period: with monthly payments, multiply by 12 for the annual rate. Payment and amount must have opposite signs.