Thread
:
Binary bit analysis
View Single Post
#
4
Bernd Plumhoff
Posts: n/a
Put your word (integer) into cell A1, select cells B1:B28 and enter
=MOD(INT($A$1/(2^(ROW()-1))),2)
with CTRL+SHIFT+ENTER (as array formula).
This will work for 28 bits (highest possible number: 268,435,455).
HTH,
Bernd
Reply With Quote