MOD()

Arithmetic remainder from integer division

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

Examples

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(m, n)

  • m - A Number.
  • n - A Number.

Notes

An m or n of a non-Number numeric type may be accepted but may produce unexpected results.

See Also

POWER()

SQRT()

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false