944,022 Members | Top Members by Rank

Hardware and Software > Microsoft Windows > Windows Software > Excel function
Ad: Download a FREE TFTP Server Tool for Network Configuration from Spiceworks
Permalink
Nov 1st, 2009
0

Excel function

Expand Post »
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.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
mistercow.pnoy is offline Offline
7 posts
since Feb 2008
Permalink
Nov 1st, 2009
0
Re: Excel function
We figured it out. But someone elses take on it would be appreciated.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
mistercow.pnoy is offline Offline
7 posts
since Feb 2008
Permalink
Feb 2nd, 2010
0
Re: Excel function
Click to Expand / Collapse  Quote originally posted by mistercow.pnoy ...
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.
Attached Files
File Type: zip Decimal to Binary into Digits.zip (4.0 KB, 37 views)
Reputation Points: 10
Solved Threads: 0
Newbie Poster
random1970 is offline Offline
11 posts
since Jun 2009
Permalink
Feb 2nd, 2010
0
Re: Excel function
Click to Expand / Collapse  Quote originally posted by random1970 ...
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.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
mistercow.pnoy is offline Offline
7 posts
since Feb 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Windows Software Forum Timeline: explanation about archiving email in outlook express
Next Thread in Windows Software Forum Timeline: Pressing number 4 changes to a three in office only ???


Tags
binary, excel



About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC