https://bugs.documentfoundation.org/show_bug.cgi?id=98609
Bug ID: 98609
Summary: MOD function does not work
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
https://help.libreoffice.org/Calc/Mathematical_Functions#MOD
MOD
Returns the remainder when one integer is divided by another.
Syntax
MOD(Dividend; Divisor)
For integer arguments this function returns Dividend modulo Divisor, that is
the remainder when Dividend is divided by Divisor.
This function is implemented as Dividend - Divisor * INT(Dividend/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.
The results are not correct for a MOD function. If the formula provided is
truly the one being used then it is wrong.
A corrected formula would be (Dividend/Divisor)-INT(Dividend/Divisor)
That will give the remainder which is being searched for when using this math
function.
Version: 5.0.5.2
Build ID: 55b006a02d247b5f7215fc6ea0fde844b30035b3
Locale: en-US (en_US)
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
