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?

ROKYD · Nov 1, 2009

Yes that is it?

But I have to use excel to do it? How must I do?
coud you please show me the windows on excell;

Kindest

ROKYD · Nov 1, 2009

<table id="post2107641" class="tborder" width="100%" align="center" border="0" cellpadding="6" cellspacing="0"><tbody><tr valign="top"><td class="alt1" id="td_post_2107641" style="border-right: 1px solid rgb(255, 255, 255);">Yes that is it?

But I have to use excel to do it? How must I do?
coud you please show me the windows on excell;

Kindest
 </td> </tr> <tr> <td class="alt2" style="border-style: none solid solid; border-color: -moz-use-text-color rgb(255, 255, 255) rgb(255, 255, 255); border-width: 0px 1px 1px;">
</td> <td class="alt1" style="border-style: none solid solid none; border-color: -moz-use-text-color rgb(255, 255, 255) rgb(255, 255, 255) -moz-use-text-color; border-width: 0px 1px 1px 0px;" align="right">
</td></tr></tbody></table>

Ron Coderre · Nov 1, 2009

There are no windows or menu items to select from.
That is an Excel formula.
Copy it or type it into your worksheet, then change the cell reference from
A1 to whatever cell you are using.

ROKYD · Nov 1, 2009

WHEN I COPY ON EXCEL, IT DISPLAY THAT THERE AN ERROR IN THE FORMULA.

PLEASE, I know that I am exhausting you, but coul you please tell me what to do now?

I am using excell 2007.

kINDEST

Ron Coderre · Nov 1, 2009

I am also using Excel 2007.
When I copy the formula from this website and paste it into my worksheet, the formula contains no errors.

You need to be very specific about what you are doing and the kind of error you are receiving.

ROKYD · Nov 1, 2009

WHEN, I COPY THE FORMULA FROM THE WEBSITE and paste on excelsheet,

I PUT THE 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]925000004000580120 " in the cel A1,

the formula is cel A2, nomalement when, it is done so, and do "" ENTER"", the error message is displayed"

When I PASTE, the formula is displayed on the lines
Is that normal?
[/FONT]

VoG · Nov 1, 2009

If you are using , as the decimal separator then you will need to replace each , in Ron's formula with ;

=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)

ROKYD · Nov 1, 2009

I am using excel in french, is that error link to that?

VoG · Nov 1, 2009

Yes. So you need the formula with ; as I posted but you will also need to find the equivalent of MOD, MIN and SUMPRODUCT in the French version of Excel.

ROKYD · Nov 1, 2009

Ok i will check.

calculating

ROKYD

New Member

ROKYD

New Member

Excel Facts

ROKYD

New Member

Ron Coderre

MrExcel MVP

ROKYD

New Member

Ron Coderre

MrExcel MVP

ROKYD

New Member

VoG

Legend

ROKYD

New Member

VoG

Legend

ROKYD

New Member

Similar threads

Forum statistics

Share this page

calculating

New Member

New Member

Excel Facts

New Member

MrExcel MVP

New Member

MrExcel MVP

New Member

Legend

New Member

Legend

New Member

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