The MOD function calculates the remainder of x divided by y according to the following formula:
MOD(x, y) = x - (y * INT(x / y))
You can calculate the fractional part of a number x using:
MOD(x,1)
See also:
INT(x)
Other mathematical functions