Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- A1 = 1791234567000
- B1 = =WERT(TEIL(TEXT($A$1;"\000000000000");(ZELLE("ROW";B1));1))
- B2 = =WERT(TEIL(TEXT($A$1;"\000000000000");(ZELLE("ROW";B2));1))
- ...
- B14 = =WERT(TEIL(TEXT($A$1;"\000000000000");(ZELLE("ROW";B14));1))
- C1 = =WENN(ISTLEER(B1);"";WENN(ISTGERADE(ZELLE("ROW";C1)-1); 1;0)* (2*WERT(B1)-(WENN(2*WERT(B1)>9;9;0))))
- C2 = =WENN(ISTLEER(B2);"";WENN(ISTGERADE(ZELLE("ROW";C2)-1); 1;0)* (2*WERT(B2)-(WENN(2*WERT(B2)>9;9;0))))
- ...
- C14 = =WENN(ISTLEER(B14);"";WENN(ISTGERADE(ZELLE("ROW";C14)-1); 1;0)* (2*WERT(B14)-(WENN(2*WERT(B14)>9;9;0))))
- D1 = =WENN(ISTUNGERADE(ZELLE("ROW";D1)-1);WERT(B1);0)
- D2 = =WENN(ISTUNGERADE(ZELLE("ROW";D2)-1);WERT(B2);0)
- ...
- D14 = =WENN(ISTUNGERADE(ZELLE("ROW";D14)-1);WERT(B14);0)
- E1 = =BIN2DEC(WECHSELN(DEC2BIN(0)+DEC2BIN(B1);2;0))
- E2 = =BIN2DEC(WECHSELN(DEC2BIN(E1)+DEC2BIN(B2);2;0))
- E3 = =BIN2DEC(WECHSELN(DEC2BIN(E2)+DEC2BIN(B3);2;0))
- ...
- E15 = =BIN2DEC(WECHSELN(DEC2BIN(E14)+DEC2BIN(B15);2;0))
- F1 = =B1*(REST(ZELLE("ROW";F1)-1;9)+1)
- F2 = =B2*(REST(ZELLE("ROW";F2)-1;9)+1)
- ...
- F15 = =B15*(REST(ZELLE("ROW";F15)-1;9)+1)
- G1 = =E15-WENN(E15>9;1;0)*6
- G2 = =REST((SUMME(C1:C14)+SUMME(D1:D14));10)
- G3 = =REST(SUMME(B1:B14);10)
- G4 = =REST(SUMME(F1:F15);10)
- H1 = =G1*1000+G2*100+G3*10+G4
Add Comment
Please, Sign In to add comment