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?