MOD function. Surplus.(Microsoft Excel)


Japanese version.

If you perform division with the arithmetic operators, you will get a decimal fraction.
If you want to get the remainder of the division, use the MOD function instead of the arithmetic operator.
If you want to get the integer part instead of the remainder, use the QUOTIENT function.
The MOD function is used infrequently by itself, but it is effective when used in combination with other functions.

How it works

=MOD(number, divisor)
numberRequired argument.The number for which you want to find the remainder.
divisorRequired argument.The number by which you want to divide number.


Since this is a division, zero division is not possible and a #DIV/0 error is displayed.


Spill if either or both of the "number" and "divisor" arguments are cell ranges.



Microsoft Excel Functions Math & Trig

Examples of Use

Formulas to extract text from a cell every specified number of letters.

Method of summing every other line.