Adding numbers together using numerology math

Hi,

See the working version on my Onerdrive called Numerology.xlsx

Note you made a mistake in your description. you said

So 8+9= 7 not 17.  5+5=1 not 10, 3+3=6, 7+6=3 not 13 and so on.

In this system 5+5=0 and not 1

The basic formula is this.

=(B15+B16)-(10*(B15+B16>=10))

https://onedrive.live.com/?cid=66A66EA84229B01B&id=66A66EA84229B01B%21108

I want to be able to add  any 3 digit number in cells B:15, F:15, J:15 N:15 and add 317

to the other numbers all the way down to BCD:35 through NOP:35 using what is call numerology math .

 You do not carry over any numbers .  So, 7+8=5 and not 15, 9+9=8 and not 18, 5+5=1 not 10 and 4+4=8 and so on

Then I want to add 123 row the 3 digit numbers that are in TUV:AF AG AH 15  all the way down to row 35 like the 317

is this possible to do?

This seems like a variation on your previous post that was answered by DanaD. In B37 enter

=MOD(B15+B16,10)

The mod function returns the modulus of a number i.e. the remainder of a number after division by another number.

 e.g. 5 mod 2 = 3; 13 mod 8 = 5

Have you marked Danas other post as helpful? :-)

This seems like a variation on your previous post that was answered by DanaD. In B37 enter

=MOD(B15+B16,10)

The mod function returns the modulus of a number i.e. the remainder of a number after division by another number.

 e.g. 5 mod 2 = 3; 13 mod 8 = 5

Have you marked Danas other post as helpful? :-)

Hi Peter, In the other post Tsos answered my question, in this application it is leaving me with double sets of numbers and also ## in D:37

If Peter is not available can someone else look at this for me?

Thank you!!!

If Peter is not available can someone else look at this for me?

Thank you!!!

You asked exactly the same question 2 days ago and I showed you how to do it and provided a working workbook. Numerology.xlsx

https://onedrive.live.com/?cid=66A66EA84229B01B&id=66A66EA84229B01B%21108

Your previous question.

http://answers.microsoft.com/en-us/office/forum/office_2010-excel/adding-numbers-together-using-numerology-math/7695c9c1-a26b-42fa-8538-b6202517cdcb

I'll merge this question with your previous.

If Peter is not available can someone else look at this for me?

Thank you!!!

You asked exactly the same question 2 days ago and I showed you how to do it and provided a working workbook. Numerology.xlsx

https://onedrive.live.com/?cid=66A66EA84229B01B&id=66A66EA84229B01B%21108

Your previous question.

http://answers.microsoft.com/en-us/office/forum/office_2010-excel/adding-numbers-together-using-numerology-math/7695c9c1-a26b-42fa-8538-b6202517cdcb

I'll merge this question with your previous.