Need help with 2 digit checksum calculation Modulo 97 ????!!!!

[Geert Pirens]

Hi you all,

Who can help me with a calculation with Modulo 97 ?????

I need a formula for Microsoft Exel to calculate a 2 digit check code.
(checksum)

All I need is that it is be done with Modulo 97, but I dont understand
mathematics verry well!

So all help and info is welcome!!!!

Here some examples:
1. Example the number: 0047946403 has the check digit 79

2. Example the number: 0062722489 has the check digit 58

3. Example the number: 0059009553 has the check digit 88

Please write me a mail: on1...@hotmail.com or in this newsgroup.

Thanks in advance for you time!!!

Kind regards,
Geert Pirens

[Hermann Kremer]

Geert Pirens schrieb in Nachricht <news:41e460ad$0$334$ba62...@news.skynet.be>...

>Hi you all,
>
>Who can help me with a calculation with Modulo 97 ?????
>I need a formula for Microsoft Exel to calculate a 2 digit check code.
>(checksum)
>All I need is that it is be done with Modulo 97, but I dont understand
>mathematics verry well!
>So all help and info is welcome!!!!
>
>Here some examples:
>1. Example the number: 0047946403 has the check digit 79
>
>2. Example the number: 0062722489 has the check digit 58
>
>3. Example the number: 0059009553 has the check digit 88

OK, all you have to do is to divide your number by 97, throw away
the integer part and keep the remainder as checksum. Examples:

101 : 97 = 1 remainder 04
194 : 97 = 2 remainder 00
999 : 97 = 10 remainder 29

and so on.
I don't use Excel, but most programming languages have a function
remainder = mod(number, module)
or alike; in C/C++ it reads
remainder = number % module;
with module = 97 in your application.

Best regards
Hermann
--

[ekochon]

Hi,

why mod 97? Is there anything special in 97*Z?

Geert Pirens schrieb: