MOD Function Explained

The MOD() function in Microsoft Excel returns the remainder of a division operation. It takes two arguments: a dividend and a divisor. It returns the remainder of the dividend divided by the divisor. For example, MOD(10,3) returns 1, since 10 divided by 3 is 3 with a remainder of 1.

MOD Function Syntax

MOD(number, divisor)

  • number: The number for which you want to find the remainder.
  • divisor: The number by which you want to divide number.