Need some help with code

[Jack-P-Winner]

This is a pyramid using lottery math in which you do not carry over a number. What I mean is for example basic math is 9+9=18 in lottery math 9+9=8. Any-who, I have become brain locked for some reason, I want to eliminate a digit from row 15 and only have 7 spaces not 8 and every adjustment I make to the code will not work errr

So what I am wanting is you will see in row 15 12340123, I want it to read 1234123 and still do the math correctly. If I need to explain in detail how to add the entire pyramid I can but it may not be needed....you make that call

 

[Luke M]

Hello again Jack!

For the first bit, about doing lottery math, use the function syntax
=MOD(A1+A2,10)
That will make sure you only retain the one's digit.

For your pyramid, I'm afraid I still don't get the math. If we reduce the length from 7 to 8, we'd need to shift the end. But, I can see that formulas are not always the same....they do something strange at the end. Perhaps this is clearer with arrows.

The 3 took values from above and to the top-left, the 6 took values from above and to right, and the 5 took value from above and top-right. Can you explain the pattern? Also, do the "<<" and ">>" symbols mean anything?

 

[Luke M]

Or, another picture

Everything sort of makes sense as pulling from left and below, until the end when we get to the 5, and it decides to ignore the 1 to the left.

 

[Jack-P-Winner]

I never realized how hard this was to explain on a forum. See if this helps

 

[Luke M]

How about a pyramid that can handle anywhere from 1 to 17 digits?

 

[Jack-P-Winner]

your too cool Luke LOL THANK YOU!!!!!!!