Forum Discussion
tkboisvert
Helper II
Helper IIUnexpected modulo behavior
Hi all, In excel, I have this formula: MOD(-10 + 9,12) + 1 And the expected result is 12 However, in PowerQuery the same formula: Number.Mod(-10 + 9, 12) + 1 Results in ...
Hi tkboisvert,
The way the formulas is calculated is slightly different between the two functions.
Check out this video: https://www.youtube.com/watch?v=K4ImPRsi3vg&ab_channel=ExcelIsFun
Kim
KNP
Super User
Super UserHi tkboisvert,
The way the formulas is calculated is slightly different between the two functions.
Check out this video: https://www.youtube.com/watch?v=K4ImPRsi3vg&ab_channel=ExcelIsFun
Kim
tkboisvertThank you!