Hi all,
I need a formula or macro to do that:
user introduce 14 numbers (6+8):
49927312345678
The formula must double the value of alternate digits beginning with the penultimate right hand digit and working left.
4 9 9 2 7 3 1 2 3 4 5 6 7 8
x x x x x x x
2 2 2 2 2 2 2
= = = = = = = = = = = = = =
8 9 18 2 14 3 2 2 6 4 10 6 14 8
I need a total with the results (individual digits)
8 + 9 + (1 + 8) + 2 + (1 + 4) + 3 + 2 + 2 + 6 + 4 + (1 + 0) + 6 + (1 + 4) + 8 = 70
and finally divide the total by ten
70/10 = 7
If someone can help me...
I need a formula or macro to do that:
user introduce 14 numbers (6+8):
49927312345678
The formula must double the value of alternate digits beginning with the penultimate right hand digit and working left.
4 9 9 2 7 3 1 2 3 4 5 6 7 8
x x x x x x x
2 2 2 2 2 2 2
= = = = = = = = = = = = = =
8 9 18 2 14 3 2 2 6 4 10 6 14 8
I need a total with the results (individual digits)
8 + 9 + (1 + 8) + 2 + (1 + 4) + 3 + 2 + 2 + 6 + 4 + (1 + 0) + 6 + (1 + 4) + 8 = 70
and finally divide the total by ten
70/10 = 7
If someone can help me...