Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Parity Check formula for binary numbers

2,438 views
Skip to first unread message

Graeme Grogan

unread,
May 6, 2003, 9:08:37 PM5/6/03
to
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?

Vasant Nanavati

unread,
May 6, 2003, 10:31:28 PM5/6/03
to
Hi:

Perhaps:

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

Regards,

Vasant.


"Graeme Grogan" <graeme...@auspost.com.au> wrote in message
news:040f01c31435$308c5030$a301...@phx.gbl...

0 new messages