  # Modular Arithmetic Visually Explained   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. I made thru 17 minutes of the video and it reminded me of why I dropped out of Algebra 2 !! Oh, man, my brain is fried .  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.