Adding numbers together using numerology math

 

I want to be able to put a 4 digit number in B:15 E:15, G:15 J:15 L:15 O:15 and Q15: T:15 and have it add 3175 10 times using what is called numerology math from B:16, B:18, B:20 and so on down to B:34 and over to Q:34.  Basically when you add 2 numbers together you do not carry over any digits.  So 8+9= 7 not 17.  5+5=1 not 10, 3+3=6, 7+6=3 not 13 and so on.

 

Question Info


Last updated February 27, 2018 Views 163 Applies to:

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

If this response answers your question then please mark as answer.

Mike H

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

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?

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

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? :-)

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

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

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

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

Thank you!!!

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

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 this response answers your question then please mark as answer.

Mike H

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

So sorry Mike, I did not see this, with a 1 year ole having double ear infections and being sick I am not all here, long 4 days  lol, my apologies

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.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.