MOD

Returns the result of the modulo operator, the remainder after a division operation.

Sample Usage

MOD(10,4)

MOD(A2,B2)

Syntax

MOD(dividend, divisor)

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

Examples

Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.

Was this article helpful?

How can we improve it?

Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.