 Formula Engine Reference Guide |
|
Back to Class Index
MOD(X, Y)
This function returns the remainder of X/Y with the same sign as X. (This function is NOT modulus as sometimes documented.)
Parameters
X
A numeric value
Y
A numeric value
Examples
MOD(8, 4) = 0
MOD(D2, F3) = 12
where D2 = 100 and F3 = 44
MOD(F5, A1) = Error - divide by zero
where F5 = 98.6 and A1 = 0
MOD(-14, 3) = -2 (the true modulus is 1)