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.