How to resolve the accounting certificate excel in a small issue.

Now a1:g4 region has the following format data

Wanqianbaishi yuan angle at
1 2 6 8 2 9 9
9 3 5 6 3 6 9
5 6 2 3 5 7 8

request:

1.in a5:g5 display and the corresponding figure out.

2.the rules:for example, “points” and 26, g5 6 , To “corner” (that is, f5) into 2, and then calculate

“angle” and, in turn forward calculation.

3.Is not limited to the number 3 line, that is, That it may be a former into a number of 5 or 6 or 7 or 8 or 9, 9 up to the.

4.Shall not be used if and mod function (I have to realize this Too, and there are limitations to this approach

If there is more than 20 data, if statements can not be used).

G5 enter
= right (sum ($ G $ 2:G4)) +0

F5 enter
= RIGHT (SUM (F $ 2:F4)) + LEFT (SUM (G $ 2:G4))

E5, and so can hold down the + F5 in the lower right corner, drag to the left for fill.

Attention:
G5 formula +0 In order to show that G5 is a numerical rather than text.
At this time A5 is shown in a single-digit, if the whole show, you should know how to.If your example, H and I set out to be blank:
G5 = MOD (SUM (G1:G4) + INT ((SUM (H1:H4) + INT (SUM (I1:I4) / 10)) / 10), 10)
G5 to copy the formula to the left B4
A5 = SUM (A1:A4) + INT ((SUM (B1:B4) + INT (SUM (C1:C4) / 10)) / 10) on the first floor of the formula tried to deal with the landlord to give This example is no problem, but if it points out the one on the 100 and that on the first floor of the formula would be a problem.That is to say the first floor of the formula is only out for each of them is a double-digit increase When the application.

Xu big brother has always admired the small tightly built, every time your answer will carefully study and research.The answer given by my table to do a bit of a problem discovered, Xu and raised question about Colombia.I can see your solution, you have found a particular (as 1000) only after the two (that is, 100 and 10) of the binary, but if this is After the column or three places after the occurrence of this binary (for example, who would have had a million> and 1000), this formula can not be dealt with in the right.Xu hope that the big brother to come up with a combination of reference and an array of more clever formula So that boy to learn about.