MOD(x, y)

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