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.

Notes

The MOD function also applies on non-integer numbers but may result in an approximate result due to the use of floating point arithmetic. You can use the ROUND function to round the output up or down to get the expected result.

Examples

true
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.

Search
Clear search
Close search
Google apps
Main menu
13699712799468672950
true
Search Help Centre
true
true
true
true
true
35