What is MOD called in Spanish?

In Spanish Google Sheets it is RESIDUO. The formula =MOD(B2,60) is written =RESIDUO(B2;60) (or with commas under a Mexico locale).

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

Returns the remainder of a division. In Spanish Sheets it is called RESIDUO.

Syntax

English Sheets

=MOD(dividend, divisor)

Spanish Sheets (Mexico locale)

=RESIDUO(dividendo, divisor)

Spanish Sheets (Spain, Latin America)

=RESIDUO(dividendo; divisor)

Argument	What it is
dividend	The number to divide.
divisor	What to divide by.

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.

=MOD(B2,60)

Common mistake

MOD(n,2)=0 tells whether n is even: handy for alternating rows or shifts. Dividing by 0 gives #DIV/0!.

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 MOD

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 MOD called in Spanish?: In Spanish Google Sheets it is RESIDUO. The formula =MOD(B2,60) is written =RESIDUO(B2;60) (or with commas under a Mexico locale).
Why does MOD 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 MOD mistake?: MOD(n,2)=0 tells whether n is even: handy for alternating rows or shifts. Dividing by 0 gives #DIV/0!.