calculating

ROKYD · Nov 1, 2009

Please, who can provide me a full formula enabling me to calculate the check digit(MOD 10) of the a given number?

PLEASE HELP ME . I NEED THE INFORMATION AS SOON AS POSSIBLE.
IAM RUSHING AND I DO NOT KNOW HOW TO OPERATE?

PA HS Teacher · Nov 1, 2009

Checkdigit is a general term.

What type of check digit are you using?

<a href="http://en.wikipedia.org/wiki/Check_digit">Check Digit</a>

Ron Coderre · Nov 1, 2009

For an urgent question, you might want to post some sample data with the results you want calculated.

In the meantime....This regular formula calculates the MOD 10 Check Digit of
an 11 "character" number:

Code:

=10-MOD(SUMPRODUCT(--MID(A1,{1,3,5,7,9,11},1))*3+SUMPRODUCT(--MID(A1,2,4,6,8,10},1)),10)

Example:
With A1: 01234567890
The formula returns a check-digit of: 5

For different length numbers, adjust the odd/even sequential arrays.

Is that something you can work with?

ROKYD · Nov 1, 2009

YES THANK YOU FOR THE REPLY.

IT IS SOME LIKE 12th VALUE IS A CONTROL VALUE THAT SHOULD BE CALCULATED AS YOU HAS SHOWN.

COULD YOU PLEASE SHOW ME THE WINDOW ON EXCEL WHERE YOU HAHE EXPERIENCE IT?

I HAVE MORE THAN 1000 LINE TO CACULATE. I NEED THE CALCUL TO BE DONE AUTOMATICALLY.

KINDEST

ROKYD · Nov 1, 2009

THE DIGIT CHECK IS ABOUT THE SERIAL NUMBER FOR EXAMPLE.
I MUST OBTAIN A VALUE ENABLING ME TO KNOW IF THE NUMBER IS RIGHT OR NOT? AND SO I WILL NEED TO ADD THE RESULT THAT I HAVE.

=10-MOD(SUMPRODUCT(--MID(A1,{1,3,5,7,9,11},1))*3+SUMPRODUCT(--MID(A1,2,4,6,8,10},1)),10)</pre>

ROKYD · Nov 1, 2009

HERE IS THE EXEMPLE DATA.

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5CDIFFI%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CDOCUME%7E1%5CDIFFI%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CDOCUME%7E1%5CDIFFI%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style>  </style>[FONT=&quot]529000004000580120

2[/FONT] = THE DIGIT VALUE THAT THEY FOUND

ROKYD · Nov 1, 2009

I AM STILL AWAITING YOUR REPLY.

THE EXEMPLE DATA IS :

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5CDIFFI%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CDOCUME%7E1%5CDIFFI%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CDOCUME%7E1%5CDIFFI%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style>  </style>[FONT=&quot]9250000040005801202[/FONT]

the last figure (2) is value taht has been found

Ron Coderre · Nov 1, 2009

ROKYD said:
I AM STILL AWAITING YOUR REPLY.

Certainly you are aware that we are NOT a paid help desk staff waiting to
serve only you, right? We volunteer our knowledge and assistance, free of
charge, in our spare time. If you need immediate answers, there are many
reputable help services you can purchase for an annual or hourly fee.

ROKYD · Nov 1, 2009

Sorry for that. I apologise for that. If you can, please ? Help me.
I need to give a reply to my client.
That is why, i was happy to read you. Because i have noticed that you were ujnderstanding waht i mean.

Once again, i apoligise for that. Help me please

Ron Coderre · Nov 1, 2009

ROKYD said:
Sorry for that. I apologise for that. If you can, please ? Help me.
I need to give a reply to my client.
That is why, i was happy to read you. Because i have noticed that you were ujnderstanding waht i mean.

Once again, i apoligise for that. Help me please

Try this:

Code:

=10-MOD(SUMPRODUCT(--MID(A1,{1,3,5,7,9,11,13,15,17},1))+
SUMPRODUCT(--MID(A1,{2,4,6,8,10,12,14,16,18},1)*3),10)

With this 18-character numeric string:
925000004000580120

The formula returns a check digit of: 2

Is that something you can work with?

calculating

ROKYD

New Member

Excel Facts

PA HS Teacher

Well-known Member

Ron Coderre

MrExcel MVP

ROKYD

New Member

ROKYD

New Member

ROKYD

New Member

ROKYD

New Member

Ron Coderre

MrExcel MVP

ROKYD

New Member

Ron Coderre

MrExcel MVP

Similar threads

Forum statistics

Share this page

calculating

New Member

Excel Facts

Well-known Member

MrExcel MVP

New Member

New Member

New Member

New Member

MrExcel MVP

New Member

MrExcel MVP

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock