Parity Check formula for binary numbers 
Author Message
 Parity Check formula for binary numbers

Need to use Excel to do a parity check on a binary number
returning either a odd or even parity result. Does anyone
have a formular or macro that can do this?


Sun, 23 Oct 2005 09:08:37 GMT  
 Parity Check formula for binary numbers
Hi:

Perhaps:

=IF(MOD(LEN(A1)-LEN(SUBSTITUTE(A1,1,"")),2),"ODD","EVEN")

Regards,

Vasant.


Quote:
> Need to use Excel to do a parity check on a binary number
> returning either a odd or even parity result. Does anyone
> have a formular or macro that can do this?



Sun, 23 Oct 2005 10:31:28 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Parity checking function in Excel

2. Formula for checking for miskeyed numbers

3. Help Please - Formula for Unique Number Series with Check Digit

4. Formula to convert an amount to words-Much like spelling out a number on a check

5. Formula Sits in the formula bar and does nothing after check mark is clicked

6. Formula sits in the formula bar and does nothing after the check mark is clicked

7. EXCEL97 - Custom formula to check if cell contents is a formula

8. Sepearting a binary number into seperate cells

9. Seperating binary numbers into seperate cells

10. Dec2Bin Function (Binary Numbers in General)


 
Powered by phpBB® Forum Software © phpBB Group