How to use MOD in Google Sheets

Product Solutions Templates Resources Pricing

MOD

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

Math

In Google Sheets, the MOD() function is used to find the remainder of a division operation. It takes two arguments: the dividend and the divisor.

For example, if you have a dividend of 10 and a divisor of 3, the MOD() function will return the value of 1, which is the remainder of the division operation 10 ÷ 3.

The syntax for using the MOD() function in Google Sheets is as follows:

=MOD(dividend, divisor)

Where "dividend" is the number being divided, and "divisor" is the number you are dividing by.

Visit Official Docs

Want even more from Google Sheets?

With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.

Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.

Try Softr now and build your custom web apps in 10 minutes – no code required!

Try Softr for Free