Search found 1 match

by mickael9
Sat Jun 29, 2019 9:24 am
Forum: Issues
Topic: Incorrect MOD function result with negative dividend
Replies: 1
Views: 134

Incorrect MOD function result with negative dividend

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) = ...