What is INT called in Spanish?

In Spanish Google Sheets it is ENTERO. The formula =INT(B2/60) is written =ENTERO(B2/60) (or with commas under a Mexico locale).

Why does INT 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 INT function

Drops the decimals, rounding down. In Spanish Sheets it is called ENTERO.

Syntax

English Sheets

=INT(value)

Spanish Sheets (Mexico locale)

=ENTERO(valor)

Spanish Sheets (Spain, Latin America)

=ENTERO(valor)

Argument	What it is
value	The number.

Example

INT drops the decimals, rounding down, and MOD(dividend, divisor) gives the remainder of a division. Together they turn minutes into hours and minutes, or pieces into packs and leftovers.

=INT(B2/60)

Common mistake

With negatives it goes to the lower integer: INT(-2.5) gives -3.

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 INT

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

INT and MOD

INT drops the decimals, rounding down, and MOD(dividend, divisor) gives the remainder of a division. Together they turn minutes into hours and minutes, or pieces into packs and leftovers.

Example=MOD(B2,60)ENTERO = INT RESIDUO = MOD

Step 1/2

In C2, calculate each movie’s full hours.

	A	B	C	D
1	Movie	Minutes	Hours	Minutes left
2	Movie A	142
3	Movie B	95
4	Movie C	181
5	Movie D	60
6	Movie E	118
7

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

Frequently asked questions

What is INT called in Spanish?: In Spanish Google Sheets it is ENTERO. The formula =INT(B2/60) is written =ENTERO(B2/60) (or with commas under a Mexico locale).
Why does INT 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 INT mistake?: With negatives it goes to the lower integer: INT(-2.5) gives -3.