From data to report in one minute or less. Ajelix BI is launched! 🚀 Get started for free.

How To Use MOD function in Excel Explained

What is MOD function in Excel?

The MOD function in Excel returns the remainder after a number is divided by a divisor. It takes two arguments: the number to be divided and the divisor. The function returns a value that represents the remainder of the division operation.

Description

The MOD function in Excel is a versatile mathematical function that can be used to perform a variety of calculations. It is used to calculate the remainder of a division operation and can be used to determine if a number is divisible by another number. The syntax of the function is MOD (number, divisor).

The function is usually used to check if a number is divisible by another number and can be useful in data analytics.

For example, if you are trying to determine if a number is divisible by 5, you can use this function to check.

If the result is 0, then the number is divisible by 5.

If the result is not 0, then the number is not divisible by 5.

This function can be used to calculate the remainder of a division operation.

For example, if you divide 16 by 3, the result is 5 with a remainder of 1.

Struggling with your Excel formulas?
Looking for a faster and easier way to write Excel formulas? Try AI Excel Formula Generator and turn your text into formulas with just a few clicks.

Try for free

Syntax

=MOD(number, divisor)

MOD function MS Excel - Excel Formula Cheat Sheet

How to use MOD function in your workbook:

  1. Open your Excel spreadsheet.
  2. Select the cell or range of cells in which you want to use the function.
  3. Enter the formula =MOD(number, divisor)
  4. Replace number and divisor with the numbers that you want to use in your calculation.
  5. Press the Enter key on your keyboard to calculate the MOD.
  6. The result will appear in the selected cell or range of cells.

Frequently Asked Questions

What does the MOD function do?

The MOD function in Excel calculates the remainder when one number (the “dividend”) is divided by another number (the “divisor”).

What is the opposite of MOD in Excel?

In Excel, the opposite of the MOD function is the QUOTIENT function. While the MOD returns the remainder of a division operation, the QUOTIENT function returns the whole number quotient of the division.