Arrow left
Back to guides
Google Sheets Formulas

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.
How to insert the MOD formula from the menu bar in Google Sheets

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.

How to use the MOD function in Google Sheets.

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.

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at:

Liked this article? Then you'll love the ones below