I tried it, but it gave zero in all cells B1:B28 for any value in A1!
What's wrong?
Stefi
€˛Bernd Plumhoff€¯ ezt Ć*rta:
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
|