EAN

mal 1

mal 3

Summe

Muss Zehner sein

EAN

mal 1

mal 3

Summe

Muss Zehner sein

A1 = 9
B1 = 7
C1 = 8
D1 = 3
E1 = 8
F1 = 2
G1 = 7
H1 = 4
I1 = 1
J1 = 7
K1 = 5
L1 = 8
A2: A1
C2: C1
E2: E1
G2: G1
I2: I1
K2: K1
B3: (B1 * 3)
D3: (D1 * 3)
F3: (F1 * 3)
H3: (H1 * 3)
J3: (J1 * 3)
L3: (L1 * 3)
N3 = Sum(A3:L3)
N2 = Sum(A2:L2)
N4: N2 + N3
M1 = 9
M5: M1 + N4
A7 = 9
B7 = 7
C7 = 8
D7 = 1
E7 = 2
F7 = 3
G7 = 4
H7 = 5
I7 = 6
J7 = 7
K7 = 8
L7 = 9
A8: A7
C8: C7
E8: E7
G8: G7
I8: I7
K8: K7
B9: (B7 * 3)
D9: (D7 * 3)
F9: (F7 * 3)
H9: (H7 * 3)
J9: (J7 * 3)
L9: (L7 * 3)
N8 = Sum(A8:L8)
N9 = Sum(A9:L9)
N10: N8 + N9
M7 = 7
M11: M7 + N10