modulus 11 formula－software｜痞客邦

Dec 25 Tue 2007 20:41
modulus 11 formula

close

has anyone had a go at setting up a formula to check that a reference number
is valid via a modulus 11 check digit? i can't find that there is a function
specifically for it.

Michelle

Michelle,
I just saw the algorithm in the internet
(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(quot;1:quot;amp;LEN( A1))),1)),
MOD(ROW(INDIRECT(quot;1:quot;amp;LEN(A1)))-1,6) 2),11)

To append the check digit to the number

=value(A1amp;_formula_)

HTH
Kostis Vezerides

software

software

software 發表在痞客邦留言(0) 人氣()

E-mail轉寄

全站分類：不設分類
個人分類：title
此分類上一篇： changes to excel worksheet that is paged
此分類下一篇： make a budget look like online banking w/ excel
上一篇： count ticks in boxes
下一篇： make a budget look like online banking w/ excel

歷史上的今天

2007: Formula to limit the size of a number result in a cell?
2007: change control properties according to a cell value
2007: How do I down load excel to open email attachment?
2007: How do I make note cards from an inventory in excel?
2007: format changes after copy/paste
2007: Need to print path amp; file on ALL excel worksheets...
2007: Import and Comparisson functions
2007: No. of digits accepted in one cell
2007: How to prevent users from changing cell format
2007: linking cells
2007: Extracting specific word in a cell
2007: Excell
2007: I need to know how to 'Colour Tabs' in Excel 2000
2007: cancel input
2007: cannot group that selection
2007: How to adjust spacing between lines of wrapped text ?
2007: vlookup
2007: Vlookup and Match
2007: Years of Service Question?
2007: automatically updating quot;school event recordquot; formula
2007: pivot page prints
2007: With 2 pivotcharts, can I keep their page selections syncronized?
2007: Printing issue from Excel
2007: assign macro
2007: Excel
2007: Text Import wizard
2007: ???Sumif(Range1,Range1lt;Range2,Range1)???
2007: Dynamic Links Excel 2003
2007: How do I insert the filename of the worksheet into a cell?
2007: Chgs in font color don't appear on screen unless wrap text is set
2007: Converting to h:mm from regular number
2007: Locking Formulas to Cells
2007: How do I graph a pivot table of sparse values?
2007: Print area
2007: can i export my excel page into a word doc?
2007: remove comment arrow
2007: worksheets xlSheetVeryHidden and show them once password-app
2007: averages
2007: If I have my sheets protected will that prevent me running a macro to hide certain sells?
2007: Chart Help -How ?
2007: Charts
2007: You guys are on the ball in here ...
2007: can't move my workbook, top bar hidden
2007: How do I use a matris(A1:B1)to get the returnvalue from kolumn C1
2007: Could someone tell me the difference in these formulas?
2007: Hyperlinks
2007: Cursor becomes a cross on mouseover?
2007: Excel links
2007: Replacing specific numbers
2007: group excel sheets within workbook
2007: Using a MODE formula in a Pivot Table
2007: Total
2007: How do i hide the field list in a pivot table?
2007: Suppress Update Links Message
2007: formula in one cell or another
2007: Templete question...I hope there is an answer
2007: VB and Excel
2007: Excel Web Queiries should work with protected web sites.
2007: The NOW function
2007: Quarterly data with years on the x-axis
2007: Help with SUMIF
2007: If Statement
2007: Change the text format for weekend days (Sat, Sun)
2007: Auto Sum and decimilization
2007: Excel should let me undo after a save
2007: conditional format business day
2007: Excel Formula
2007: Why does the right 'Alt' key not work in Excel?
2007: Make Excel add
2007: Adding or pasting a row, but having info shift upwards not down??
2007: Splitting data in a single cell that is seperated by commas, then moving to make individual rows
2007: HOW TO: In a formula, how to change the format of the resulting te
2007: macro security warning when no maco in workbook
2007: calculating total time
2007: Copying a format that has been conditionally formated
2007: XIRR non contiguous references
2007: How can I extend the filtering limits of 1000 unique entries
2007: If B2 = anything in column C, add A1
2007: cluster amp; stacked amp; line in one chart
2007: I need a formula
2007: Finding the greatest value
2007: How to match the Coloums
2007: Leading zero with fractions
2007: if the cell value exceeds the limit to have a dialog box appear
2007: How can I draw a Parabola in Excel? like y = x^2 3
2007: maturity schedule fixed inc securities by month, quarter and year
2007: Converting Macro to Perl
2007: Software to download Fixed Width Files
2007: Calculating Per Diem Rates
2007: Copy amp; Insert from another xls
2007: Problem solving div/0 error in a zero value cell
2007: Display quot; quot; when appropriate
2007: Replacing Linked Cell Values w/ Current Values
2007: cell formatting
2007: Replace with single tick
2007: creating hyperlink excel 2003 vba
2007: count duplicate records in a group
2007: Close Dos from Vba?
2007: x and y axis, enter x value, enter y value, value at intersect....
2007: General Question About PivotTables

留言列表

站方公告

活動快報

newdirect

看更多活動好康

我的好友

熱門文章

文章分類

最新文章

最新留言

動態訂閱

文章精選

所有文章列表

文章搜尋

新聞交換(RSS)

誰來我家

參觀人氣

本日人氣：
累積人氣：

QR Code

qrcode

POWERED BY

(登入)