MOD Function in Google Sheets: Explained

In this article, you will learn the MOD function and how to use it. 

‍

What is the MOD formula in Google Sheets?

The MOD function works as an operator called the modulo operator (abbreviated as mod). When you assume 17 divided by 3, the quotient is 5, and the remainder is 2. In that case, we can say 17 mod 3 is equal to 2. In summary, the MOD formula returns a remainder for a dividend, and a divider entered.

‍

How to use the MOD function in Google Sheets

1. Type “=MOD” or go to “Insert” → “Function” (or directly navigate to the “Functions” icon)  → “Math” → “Mod”.
2. Input a dividend and a divider by cell reference and manual input
3. Press the “Enter” key.

‍

The general syntax is as follows:

=MOD(dividend, divider)

Dividend: a number to be divided by a divider

Divider: a number to divide by

‍

Learn how to use the formula with examples. Look at the screenshot below.

‍

The top example shows a case you input the arguments manually. The second one contains the SUM function and AVERAGE function for “dividend” and “divider”, respectively. As you can see, you can use a number, which is returned by a function, as an argument in the MOD formula. SUM(5,7) equals 12 and AVERAGE(4,6,5) is equal to 5. Thus, the second MOD formula returns 2. The third example includes two cell references as arguments.