I need a macro to do this
Say I have the number 79298. I need to number each number to the left of the last number from 1 to 4 (or more if there are more numbers), from left to right.
79298
4321
Then multiply the number by the number assigned to it and add them up.
(9*1) + (2*2) + (9*3) + (7*4) = 9 + 4 +27 +28 = 68
After that I need to check that the last number in the sum (i.e. 68) is equal to the last number in the original number (79298) which in this case it is.
p.s. Also, any idea for a shorter title??
Say I have the number 79298. I need to number each number to the left of the last number from 1 to 4 (or more if there are more numbers), from left to right.
79298
4321
Then multiply the number by the number assigned to it and add them up.
(9*1) + (2*2) + (9*3) + (7*4) = 9 + 4 +27 +28 = 68
After that I need to check that the last number in the sum (i.e. 68) is equal to the last number in the original number (79298) which in this case it is.
p.s. Also, any idea for a shorter title??