Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Excel and Binary numbers

  1. #1
    Join Date
    29th April 2003
    Posts
    2
    Is there any way to add binary numbers and inverse them using excel?

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    31st January 2003
    Location
    Toronto Canada
    Posts
    665
    You could convert binary to decimal by using the =bin2dec(a1) formula, add the numbers, then convert back with =dec2bin(a1)
    Hope this helps, Doug

  3. #3
    Join Date
    29th April 2003
    Posts
    2
    I need to add the actual binary values and perform operations on the binary values

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    30th April 2003
    Location
    Madison, WI, USA
    Posts
    71
    I've been doing a lot with binaries lately. I've been converting the base ten numbers to binary using dec2bin or some sort of looping function for conversion (tell me if you want the code). And then, since I've found that Excel can't handle numbers with more than 15 digits in them without forgetting the last few, I convert the binary string to an array. If you have two arrays, you should then be able to add them together, carry the two's, and manipulate however you wish. After that, it's fairly simple to convert back to base ten.

    Kabong

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Graphing And Binary Data
    By shaunk in forum EXCEL HELP
    Replies: 2
    Last Post: September 21st, 2006, 18:36
  2. Hex to binary
    By csj1 in forum EXCEL HELP
    Replies: 3
    Last Post: February 21st, 2006, 23:02
  3. Recordset in a binary file
    By taske in forum EXCEL HELP
    Replies: 13
    Last Post: September 29th, 2004, 21:44
  4. VBA: Binary Files
    By the_sleeper in forum EXCEL HELP
    Replies: 6
    Last Post: November 12th, 2003, 19:27

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno