Math and Trignometric - MOD Function

Description

The MOD function returns the remainder after number is divided by divisor. The result has the same sign as divisor.

Syntax

MOD (number, divisor)

Arguments

Argument Description Required/Optional
Number The number for which you want to find the remainder. Required
Divisor The number by which you want to divide number. Required

Notes

  • The MOD function can be expressed in terms of the INT function −

    MOD (n, d) = n - d*INT (n/d)

  • If divisor is 0, MOD returns the #DIV/0! error value

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example

MOD Function
advanced_excel_math_trigonometric_functions.htm
Advertisements