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



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

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


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

See also



Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

Clear search
Close search
Google apps
Main menu