This function returns the remainder of a division operation.
MOD(dividend,divisor)
This function has these arguments:
Argument | Description |
---|---|
dividend | Number for which you want to find the remainder by dividing the divisor into it |
divisor | Number by which you want to divide the dividend argument |
The remainder has the same sign as the divisor.
Accepts numeric data for both arguments. Returns numeric data.
MOD(B3,10)
MOD(C4,B2)
MOD(R1C2,12)
MOD(255,16) gives the result 15
MOD(-3,2) gives the result 1