View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default modulus 11 formula

Michelle,
I just saw the algorithm in the internet
(http://docs.hp.com/en/32209-90024/apds02.html)

the following formula calculates the check digit of a number in A1.

=11-MOD(SUMPRODUCT(VALUE(MID(A1,ROW(INDIRECT("1:"&LEN( A1))),1)),
MOD(ROW(INDIRECT("1:"&LEN(A1)))-1,6)+2),11)

To append the check digit to the number

=value(A1&_formula_)

HTH
Kostis Vezerides