MOD()

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()