| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vezerid Modulus 11
thank you, I shall give it a go
"vezerid" wrote: Michelle, I just realized there was a detail in the algorithm I overlooked. The following formula is, I believe, correct (at least it produces 2 for the specific number; if you have other numbers that you can check manually, or you already know the answer, you can check these as well). =11-MOD(SUMPRODUCT(VALUE(MID(A1,ROW(INDIRECT("1:"&LEN( A1))),1)),MOD(LEN(A1)+1-ROW(INDIRECT("1:"&LEN(A1)))-1,6)+2),11) Again it has to be array entered. HTH Kostis Vezerides |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| modulus 11 formula | Excel Worksheet Functions | |||
Hybrid Mode
