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

BInary math, Logical Operators??

12 views
Skip to first unread message

Ross

unread,
May 28, 2003, 2:38:05 PM5/28/03
to

I want to do some binary operations in excel, but see no
boolean operators available.

E.g. if I want to take 10 bit binary number, mask a few
bits, shift bits left or right, Xor/toggle a bit....

All these very common programmatic functions don't seem to
exist. I'd love to try out some stuff in excel before
coding it into software elsewhere.

Am I missing something? All I can find is Dec2bin and
similar converters.

Ross.

Dave Peterson

unread,
May 28, 2003, 8:25:39 PM5/28/03
to
Harlan Grove posted some worksheet formulas that might help you:
http://groups.google.com/groups?threadm=Tdbe9.14846%24jG2.1085143%40bgtnsc05-news.ops.worldnet.att.net
(one line in your browser)

Read the whole thread--there's a correction at the end.

And Myrna Larson posted some code:
http://groups.google.com/groups?threadm=23vg6to7jh0vj1q31og7bor01ugn161388%404ax.com
(again, one line in your browser)

--

Dave Peterson
ec3...@msn.com

0 new messages