SHOW:
|
|
- or go back to the newest paste.
| 1 | - | A1 = 1791234567000 |
| 1 | + | A1 = 1790000000000 |
| 2 | ||
| 3 | - | B1 = =WERT(TEIL(TEXT($A$1;"\000000000000");(ZELLE("ROW";B1));1))
|
| 3 | + | B1 = =VALUE(MID(TEXT($A$1;"\000000000000");(CELL("ROW";B1));1))
|
| 4 | - | B2 = =WERT(TEIL(TEXT($A$1;"\000000000000");(ZELLE("ROW";B2));1))
|
| 4 | + | B2 = =VALUE(MID(TEXT($A$1;"\000000000000");(CELL("ROW";B2));1))
|
| 5 | ... | |
| 6 | - | B14 = =WERT(TEIL(TEXT($A$1;"\000000000000");(ZELLE("ROW";B14));1))
|
| 6 | + | B14 = =VALUE(MID(TEXT($A$1;"\000000000000");(CELL("ROW";B14));1))
|
| 7 | ||
| 8 | - | C1 = =WENN(ISTLEER(B1);"";WENN(ISTGERADE(ZELLE("ROW";C1)-1); 1;0)* (2*WERT(B1)-(WENN(2*WERT(B1)>9;9;0))))
|
| 8 | + | C1 = =IF(ISBLANK(B1);"";IF(ISEVEN(CELL("ROW";C1)-1);1;0)*(2*VALUE(B1)-(IF(2*VALUE(B1)>9;9;0))))
|
| 9 | - | C2 = =WENN(ISTLEER(B2);"";WENN(ISTGERADE(ZELLE("ROW";C2)-1); 1;0)* (2*WERT(B2)-(WENN(2*WERT(B2)>9;9;0))))
|
| 9 | + | C2 = =IF(ISBLANK(B2);"";IF(ISEVEN(CELL("ROW";C2)-1);1;0)*(2*VALUE(B2)-(IF(2*VALUE(B2)>9;9;0))))
|
| 10 | ... | |
| 11 | - | C14 = =WENN(ISTLEER(B14);"";WENN(ISTGERADE(ZELLE("ROW";C14)-1); 1;0)* (2*WERT(B14)-(WENN(2*WERT(B14)>9;9;0))))
|
| 11 | + | C14 = =IF(ISBLANK(B14);"";IF(ISEVEN(CELL("ROW";C14)-1);1;0)*(2*VALUE(B14)-(IF(2*VALUE(B14)>9;9;0))))
|
| 12 | ||
| 13 | - | D1 = =WENN(ISTUNGERADE(ZELLE("ROW";D1)-1);WERT(B1);0)
|
| 13 | + | D1 = =IF(ISODD(CELL("ROW";D1)-1);VALUE(B1);0)
|
| 14 | - | D2 = =WENN(ISTUNGERADE(ZELLE("ROW";D2)-1);WERT(B2);0)
|
| 14 | + | D2 = =IF(ISODD(CELL("ROW";D2)-1);VALUE(B2);0)
|
| 15 | ... | |
| 16 | - | D14 = =WENN(ISTUNGERADE(ZELLE("ROW";D14)-1);WERT(B14);0)
|
| 16 | + | D14 = =IF(ISODD(CELL("ROW";D14)-1);VALUE(B14);0)
|
| 17 | ||
| 18 | - | E1 = =BIN2DEC(WECHSELN(DEC2BIN(0)+DEC2BIN(B1);2;0)) |
| 18 | + | E1 = =BIN2DEC(SUBSTITUTE(DEC2BIN(0)+DEC2BIN(B1);2;0)) |
| 19 | - | E2 = =BIN2DEC(WECHSELN(DEC2BIN(E1)+DEC2BIN(B2);2;0)) |
| 19 | + | E2 = =BIN2DEC(SUBSTITUTE(DEC2BIN(E1)+DEC2BIN(B2);2;0)) |
| 20 | - | E3 = =BIN2DEC(WECHSELN(DEC2BIN(E2)+DEC2BIN(B3);2;0)) |
| 20 | + | E3 = =BIN2DEC(SUBSTITUTE(DEC2BIN(E2)+DEC2BIN(B3);2;0)) |
| 21 | ... | |
| 22 | - | E15 = =BIN2DEC(WECHSELN(DEC2BIN(E14)+DEC2BIN(B15);2;0)) |
| 22 | + | E15 = =BIN2DEC(SUBSTITUTE(DEC2BIN(E14)+DEC2BIN(B15);2;0)) |
| 23 | ||
| 24 | - | F1 = =B1*(REST(ZELLE("ROW";F1)-1;9)+1)
|
| 24 | + | F1 = =B1*(MOD(CELL("ROW";F1)-1;9)+1)
|
| 25 | - | F2 = =B2*(REST(ZELLE("ROW";F2)-1;9)+1)
|
| 25 | + | F2 = =B2*(MOD(CELL("ROW";F2)-1;9)+1)
|
| 26 | ... | |
| 27 | - | F15 = =B15*(REST(ZELLE("ROW";F15)-1;9)+1)
|
| 27 | + | F15 = =B15*(MOD(CELL("ROW";F15)-1;9)+1)
|
| 28 | ||
| 29 | - | G1 = =E15-WENN(E15>9;1;0)*6 |
| 29 | + | G1 = =E15-IF(E15>9;1;0)*6 |
| 30 | - | G2 = =REST((SUMME(C1:C14)+SUMME(D1:D14));10) |
| 30 | + | G2 = =MOD((SUM(C1:C14)+SUM(D1:D14));10) |
| 31 | - | G3 = =REST(SUMME(B1:B14);10) |
| 31 | + | G3 = =MOD(SUM(B1:B14);10) |
| 32 | - | G4 = =REST(SUMME(F1:F15);10) |
| 32 | + | G4 = =MOD(SUM(F1:F15);10) |
| 33 | ||
| 34 | H1 = =G1*1000+G2*100+G3*10+G4 |
