Results 1 to 3 of 3

Binary (concatenated from Decimal) to Hex Conversion Error

Threaded View

  1. #1
    Registered User
    Join Date
    02-13-2014
    Location
    Somewhere, Rainbow
    MS-Off Ver
    Excel 2007
    Posts
    20

    Question Binary (concatenated from Decimal) to Hex Conversion Error

    I am taking a decimal degree (longitude) and converting it to binary then to hexadecimal. The value I am using is a Binary Angle 32 bit structure that will be translated into an 4-byte hexadecimal (with two characters per byte i.e. "20" is one byte and results in spaces).

    This is what I have:

    Input of 359.999999916 (in cell A2)
    Cells B2 through AG2 I have converted A2 into binary (using formulas like "=IF(A2-180>0,1,0)" for cell B2, "=IF(A2-180*B2-90>0,1,0)" for cell C2, "=IF(A2-180*B2-90*C2-45>0,1,0)" for cell D2, and so on)

    I then concatenated all of the results into one cell using the following formula:
    =CONCATENATE(B2,C2,D2,E2,F2,G2,H2,I2,J2,K2,L2,M2,N2,O2,P2,Q2,R2,S2,T2,U2,V2,W2,X2,Y2,Z2,AA2,AB2,AC2,AD2,AE2,AF2,AG2)

    To get a result of (located in cell A4):
    11111111111111111111111111111110

    However, when I attempted to use the BIN2HEX conversion on A4, I get a "NUM!" error. Here is the formula that I was using in cell A5:
    =BIN2HEX(A4,8)

    What did I do wrong?

    Any assistance is greatly appreciated!

    Respectfully,
    Talamon
    Last edited by Talamon; 02-19-2014 at 01:54 PM. Reason: Questioned solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. decimal to 16 bits binary conversion in Excel?
    By xcgames in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-05-2019, 09:15 AM
  2. binary conversion
    By binaryuser in forum Excel General
    Replies: 1
    Last Post: 09-08-2006, 09:58 AM
  3. [SOLVED] Hexadecimal to Binary Conversion
    By sean_f in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-04-2006, 04:05 PM
  4. decimal to binary
    By boardmaker in forum Excel General
    Replies: 4
    Last Post: 06-13-2006, 04:10 PM
  5. [SOLVED] decimal to binary conversion
    By tam in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-29-2005, 01:05 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1