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
Greg_Deckler
Community Champion
Community Championtkboisvert According to Modulo Calculator (calculators.org), Power Query is correct.