Excel Function: MOD

puneet-gogia-excel-champs

- Written by Puneet

MOD is a part of Excel’s Maths Functions. It returns the remainder value after dividing a number with a divisor. In simple words, it returns that value that remains after the division.

mod-function

Syntax

MOD(number, divisor)

Arguments

  • number: a number which you want to divide.
  • divisor: a number with which you want to divide.

Example

In the below example, we have used MOD with the different types of values:

used-mod-with-different-values
  1. If there is no remainder after dividing two numbers, it returns zero.
  2. If there is a decimal in the divisor it considers that decimal and returns the result according to that.
  3. If you specify zero to divide, it returns a 0 in the result. Dividing any number by zero results in zero.
  4. If the divisor will zero, it will return #DIV/0!.
  5. If you skip specifying any number for dividing it will return 0 in the result.
  6. And if you skip specifying any divisor, it will return #DIV/0!.
  7. It will consider negative values and return the same sign that the divisor has.

Important Points

  • It will return a #DIV/0! error if the divisor is zero.
  • It always returns a result with the same sign as the divisor.
Last Updated: October 29, 2023