Explainry Tutorials to Expert in IT

MOD function

The MOD function returns the remainder when two numbers are divided. For example, the formula =MOD(12,2) return the remainder 0.


MOD(number, divisor)

The function has the following arguments:

number – Required. The number for which division is desired to get the remainder.

divisor – Required. The number to be used for division.


MOD returns the #DIV/0! error value, if divisor is 0. For more detail on the function visit Microsoft Office official website.

Usage of the MOD function

How to determine if a number is even or odd.

Copyright © 2016 - 2020 Explainry.com | All Rights Reserved