Page 1 of 1

Incorrect MOD function result with negative dividend

Posted: Sat Jun 29, 2019 9:24 am
by mickael9
The MOD function does not yield correct results for negative dividends, eg:

With OnlyOffice:
MOD(-10; 5) = 0
MOD(-9; 5) = 4
MOD(-8; 5) = 3
MOD(-7; 5) = 2
MOD(-6; 5) = 1
MOD(-5; 5) = 0

With Excel/Google sheets/Libreoffice (or with the formula A-B*INT(A/B))
MOD(-10; 5) = 4
MOD(-9; 5) = 1
MOD(-8; 5) = 2
MOD(-7; 5) = 3
MOD(-6; 5) = 4
MOD(-5; 5) = 0

Re: Incorrect MOD function result with negative dividend

Posted: Mon Jul 01, 2019 7:40 am
by Kate
Hello,

Would you please send us the file for testing at support@onlyoffice.com?

What ONLYOFFICE solution did you use?