Member Avatar for mistercow.pnoy

Okay, I know this is really really simple, but for the life of me, my brother and I cannot get this to work properly.

  • We have a number in Cell D4(and down).
  • In E5 is the binary conversion of D4.
  • In F2-N2 we want to have the individual numbers of the binary sequence.

ie: In D4 is 258. So F2 should display 1. G2-L2 should display 0. M2 should have 1 and N2 should have 0

I need the functions that go in F2-N2. Can someone please help me. I've been torturing myself over it for the last 3 hours and I know it's really simple.

  • 2 Contributors
  • 3 Replies
  • 129 Views
  • 3 Months Discussion Span
  • Latest Post Latest Post by mistercow.pnoy
Member Avatar for mistercow.pnoy

We figured it out. But someone elses take on it would be appreciated.

Member Avatar for random1970

We figured it out. But someone elses take on it would be appreciated.

The easiest option is to use the MID and COLUMN functions. I've attached a spreadsheet which shows how this is done, and explains it too.

Decimal_to_Binary_into_Digits.zip (3.96 KB)
Member Avatar for mistercow.pnoy

The easiest option is to use the MID and COLUMN functions. I've attached a spreadsheet which shows how this is done, and explains it too.

Oh man, that's perfect. It's the idea that I had to do it, I just didn't know how to implement it.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.