In mathematics, modular arithmetic is a system of arithmetic for integers, where numbers "wrap around" upon reaching a certain value the modulus (plural moduli).
The MOD function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the MOD function can be entered as part of a formula in a cell of a worksheet.
Using modulo function on pick3 game would be mod(10) since there are 10 numbers. On your data manipulation any result that is greater than 9 will wrap around. For example: pick3 lotto math for addition 6+7=3. To do this in excel using modulo function would be =mod((6+7),10)
The same concept can be applied to any lotto game. Another example using pick5 from a poll of 36 numbers would be =mod((x+y),36). Thus if x+y>36 ,the result will wrap around.