|Posted: May 12, 2007, 8:53 pm - IP Logged|
If you have your sum of 15 in cell A1
In cell B1 enter the following formula =IF(A1<10,"",LEFT(A1))
In cell C1 enter the following formula =IF(A1<10,A1,RIGHT(A1))
There are other formlas you can use.
The sums range from 0 through 27 so I'm thinking you will have single digit sums.
The "B" column will have the "tens" and the "C" column will have the "ones".