MOD function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Trigonometric
Hyperbolic
Rounding and remainders
Logarithm/Powers
Bessel functions
Miscellaneous
MOD
Returns the remainder when one integer is divided by another.
Syntax:
MOD(number; divisor)
- For integer arguments this function returns number modulo divisor, that is the remainder when number is divided by divisor.
- This function is implemented as number - divisor * INT(number/divisor) , and this formula gives the result if the arguments are not integer.
Example:
MOD(22; 3)
- returns 1, the remainder when 22 is divided by 3.
MOD(11.25; 2.5)
- returns 1.25.
See Also
