In Numerology, it is often a task to add the digits till the result is a single digit. For example, 74 = 7 + 4 = 11 = 1 + 1 = 2
23 = 2 + 3 = 5
78 = 7 + 8 = 15 = 1 + 5 = 6
1234567 = 1 + 2 + 3 + 4 + 5 + 6 + 7 = 28 = 2+ 8 = 10 = 1+ 0 = 1
The formula to achieve the same is
=MOD(A1-1,9)+1
It nice thought to write this Tips.
Hats of you sir.
Why formula is not =MOD(A2,9) it gives same result. where is the fallback
how about 9+9 =9? if use mod 9+9=1
Thank you for this, how do I add the exclusion to avoid reducing the master numbers like 11, 22, 33. What would be the formula that can be added to this MOD formula.
Can you please elaborate the requirement? What would be the answer for 11, 66, 99 etc. Will the answer be 11, 66, 99?
So for example if I am using this formula to calculate the Expression or Soul Urge number, as per Pythagorean Numerology
11 or 22 or 33 are master numbers, we do not reduce the master numbers further.
Thus using the MOD formula will need to add these exceptions. If my Soul Urge comes to 11, or 22 it should not be reduced further, however if my soul urge is anything other than 11, 22 or 33, it should be reduced further.
Eg: 11 shouldn't be reduced to 2.
So was checking if theres any exception formula that can be added on the same cell with MOD, or on a different cell.
So for example if I am using this formula to calculate the Expression or Soul Urge number, as per Pythagorean Numerology
11 or 22 or 33 are master numbers, we do not reduce the master numbers further.
Thus using the MOD formula will need to add these exceptions. If my Soul Urge comes to 11, or 22 it should be reduced further, however if my soul urge is anything other than 11, 22 or 33, it should be reduced further.
Eg: 11 shouldn't be reduced to 2.
So was checking if theres any exception formula that can be added on the same cell with MOD, or on a different cell.
Sorry a typo: Thus using the MOD formula will need to add these exceptions. If my Soul Urge comes to 11, or 22 it *should not* be reduced further, however if my soul urge is anything other than 11, 22 or 33, it should be reduced further.