MOD()

Arithmetic remainder from integer division

Returns the remainder of dividend divided by divisor (Number value). The result will have the same sign as dividend.

Sample usage

MOD([Minutes], 60) : the number of minutes in excess of the whole hours represented by the Minutes column. Whole hours may be computed with [Minutes] / 60.

MOD([Hours], 24) returns the number of hours in excess of the whole days represented by the Hours column. Whole days may be computed with [Hours] / 24.

MOD([Days], 7) returns the number of days in excess of the whole weeks represented by the Days column. Whole weeks may be computed with [Days] / 7.

MOD(9, 7) returns 2

MOD(-9, 7) returns -2

MOD(9, -7) returns 2

MOD(-9, -7) returns -2

MOD(9, 0) returns 0

MOD(9, 9) returns 0

Syntax

MOD(dividend,divisor)

  • dividend - Number for which you want to find the remainder.

  • divisor - Number by which you want to divide the number. 

Notes

A non-Number numeric type may be accepted for either argument, but may produce unexpected results.

See also

POWER()

SQRT()

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
16377557496670954785
true
Search Help Center
true
true
true
false
false