Returns the result of the modulo operator, the remainder after a division operation.
dividend– The number to be divided to find the remainder.
divisor– The number to divide by.
MOD function also applies on non-integer numbers but may result in an approximate result due to the use of floating point arithmetic. You can use the
ROUND function to round the output up or down to get the expected result.