Free Online Tutorials on Spreadsheets

MOD function

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

Syntax

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.

Example

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 - 2019 Explainry.com | All Rights Reserved