olgagutten

Calculation to substitute the numbers

Discussion created by olgagutten on Mar 15, 2012
Latest reply on Mar 26, 2012 by olgagutten

Dear All,

 

I need help to solve this calculation:

 

1. I have 8 digit unsorted number, I need to find least significant number from right to left and multiply by 2,

2. The next least significant number is multiplied by 3,

3. The next least significant number is multiplied by 4 and so on.

The results of these multiplications are added up into sum.

 

I have already tried to do the custom function: to sort the numbers in ascending order like (SortValues ( list ; sortAscending )); and then substitude function to substitude each subsequent number by that calculation, but it does not work. It will not even allow me to create the custom sort function.

 

Could anyone, please, help me ?

Outcomes