I had posted a relatively simpler problem Challenge 31 – Increment All Digits by 1 which talked about adding 1 to all digits i.e. if your number is 7409, you needed to add 7409+1111 and come up with the answer of 8520.
I had also posted Tips & Tricks 119 – Numerology Sum of the Digits aka Sum the Digits till the result is a single digit. In this, I had explored how to add a number and arrive at a single digit. For example, if you have to add 8 + 7 the answer would be 15. You need to further add up 1 and 5 of 15 and final answer would be 6. And this is numerological sum.
Now, the challenge before you is to combine both the approaches and come up with the answer. Hence, if you have been given a number and you have to add those many 7's and you have to perform Numerological Sum on individual digits.
Example
1. Given number is 356 in cell A1, hence you need to add 777 to it. 356+777 = (3+7) (5+7) (6+7) = (10) (12) (13) = (1+0) (1+2) (1+3) = 134
2. Given number is 4072 in cell A1, hence you need to add 7777 to it. 4072 + 7777 = (4+7) (0+7) (7+7) (2+7) = (11) (7) (14) (9) = (1+1) (7) (1+4) (9) = 2759
Come up with a formula to do this (you can also do it in VBA, if you wish though formula is preferable). It should be able to do it for any number of digits. Excel can store numbers with 15 significant digits.
The solution to this problem will be published after a month i.e. on 16-Feb-16.
For example, if you have to add 8 + 7 the answer would be 15. You need to further add up 1 and 5 of 15 and final answer would be 6. And this is numerological sum. Where such information?