| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Recalculating a Regression Output in Data Analysis | Excel Worksheet Functions | |||
| Binary Numbers longer than 10 characters | Excel Worksheet Functions | |||
| Why " data analysis plus " override " data analysis " once instal. | Excel Worksheet Functions | |||
| Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) | |||
Threaded Mode
