Revision as of 00:14, 19 March 2024 (view source) Luizluca (talk \| contribs) m (→‎{{header\|Excel\|Excel}}) ← Older edit		Revision as of 00:16, 19 March 2024 (view source) Luizluca (talk \| contribs) (→‎{{header\|Excel\|Excel}}) Newer edit →
Line 1,186: =={{header\|Excel\|Excel}}== Place your number in A1 and the formula at any cell. <syntaxhighlight lang="excel"> =REDUCE(0,MID(A2A1,SEQUENCE(1,LEN(A2A1)),1),LAMBDA(i,j,INDEX({0,3,1,7,5,9,8,6,4,2;7,0,9,2,1,5,4,8,6,3;4,2,0,6,8,7,1,3,5,9;1,7,5,0,9,8,3,4,2,6;6,1,2,3,0,4,5,9,7,8;3,6,7,4,2,0,9,5,8,1;5,8,6,9,7,2,0,1,3,4;8,9,4,5,3,6,2,0,1,7;9,4,3,8,6,1,7,2,0,5;2,5,8,1,4,3,6,7,9,0},i+1,j+1))) </syntaxhighlight> Line 1,193 ⟶ 1,196: <syntaxhighlight lang="excel"> =REDUCE(0,arrayformula(MID(A2A1,SEQUENCE(1,LEN(A2A1)),1)),lambda(i,j,INDEX({0,3,1,7,5,9,8,6,4,2;7,0,9,2,1,5,4,8,6,3;4,2,0,6,8,7,1,3,5,9;1,7,5,0,9,8,3,4,2,6;6,1,2,3,0,4,5,9,7,8;3,6,7,4,2,0,9,5,8,1;5,8,6,9,7,2,0,1,3,4;8,9,4,5,3,6,2,0,1,7;9,4,3,8,6,1,7,2,0,5;2,5,8,1,4,3,6,7,9,0},i+1,j+1))) </syntaxhighlight> For countries that uses comma as a decimal divisor, use: <syntaxhighlight lang="excel"> =REDUCE(0;MID(A2;SEQUENCE(1;LEN(A2));1);lambda(i;j;INDEX({0\3\1\7\5\9\8\6\4\2;7\0\9\2\1\5\4\8\6\3;4\2\0\6\8\7\1\3\5\9;1\7\5\0\9\8\3\4\2\6;6\1\2\3\0\4\5\9\7\8;3\6\7\4\2\0\9\5\8\1;5\8\6\9\7\2\0\1\3\4;8\9\4\5\3\6\2\0\1\7;9\4\3\8\6\1\7\2\0\5;2\5\8\1\4\3\6\7\9\0};i+1;j+1))) </syntaxhighlight>

Damm algorithm: Difference between revisions

Damm algorithm (view source)