MOD pitfall 1: Sign of the result follows the divisor in Sheets, not the dividend?

Sign of the result follows the divisor in Sheets, not the dividend. `MOD(-5, 3)` returns `1`, not `-2`.

MOD pitfall 2: Dividing by zero returns #DIV/0!?

Dividing by zero returns `#DIV/0!`. Wrap in `IFERROR` if the divisor may be zero.

Matheasy

Returns the remainder after dividing one number by another. MOD(10, 3) = 1.

Syntax

=MOD(dividend, divisor)

Arguments

Argument	Description
dividend	The number to be divided to find the remainder.
divisor	The number to divide by.

Example

=MOD(10, 3)

Paste this into Google Sheets to run it. The live playground on this site covers 24 of the 61 functions, and MOD isn't one of them yet.

Sign of the result follows the divisor in Sheets, not the dividend. MOD(-5, 3) returns 1, not -2.
Dividing by zero returns #DIV/0!. Wrap in IFERROR if the divisor may be zero.

Related formulas