It's not complicated it just looks that way.
I am adding up each individual digit in a cell and then adding the number of digits to the sum of the individual digits. Read it twice if I lost you.
Step 1 in K6 - K12 put the following:
11,111,111.11 then
1,111,111.11 then
111,111.11 then
11,111.11
1,111.11
111.11
11.11
Here is the formula I have so far to handle through row K10:
=IF(LEN(TEXT(--SUBSTITUTE(ROUND(K6,2)&"",".",""),"0#"))=10,SUM(LEFT(K6,1)+MID(K6,2,1)+MID(K6,3,1)+MID(K6,4,1)+MID(K6,5,1)+MID(K6,6,1)+MID(K6,7,1)+MID(K6,8,1)+MID(K6,10,1))+MID(K6,11,1),IF(LEN(TEXT(--SUBSTITUTE(ROUND(K6,2)&"",".",""),"0#"))=9,SUM(LEFT(K6,1)+MID(K6,2,1)+MID(K6,3,1)+MID(K6,4,1)+MID(K6,5,1)+MID(K6,6,1)+MID(K6,7,1)+MID(K6,9,1)+MID(K6,10,1)),IF(LEN(TEXT(--SUBSTITUTE(ROUND(K6,2)&"",".",""),"0#"))=8,SUM(LEFT(K6,1)+MID(K6,2,1)+MID(K6,3,1)+MID(K6,4,1)+MID(K6,5,1)+MID(K6,6,1)+MID(K6,8,1)+MID(K6,9,1)),IF(LEN(TEXT(--SUBSTITUTE(ROUND(K6,2)&"",".",""),"0#"))=7,SUM(LEFT(K6,1)+MID(K6,2,1)+MID(K6,3,1)+MID(K6,4,1)+MID(K6,5,1)+MID(K6,7,1)+MID(K6,8,1)),IF(LEN(TEXT(--SUBSTITUTE(ROUND(K6,2)&"",".",""),"0#"))=6,SUM(LEFT(K6,1)+MID(K6,2,1)+MID(K6,3,1)+MID(K6,4,1)+MID(K6,6,1)+MID(K6,7,1)),"'TRY AGAIN")))))+LEN(TEXT(--SUBSTITUTE(ROUND(K6,2)&"",".",""),"0#"))
The problem is once I get to the formula for K10 it no longer works?
Any ideas why it won't work for K10, K11, and K12