Help with Complex Formulas
Results 1 to 2 of 2

Thread: Help with Complex Formulas
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Dec 2013
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)

    Default Help with Complex Formulas

    Hi All,

    This may not be complex to the power users, but I'm struggling to come up with this formula for B2 and C2. Here is what I'm trying to do:

    Take the value in A2 (141635858), which is the only known value and convert it from DEC2HEX resulting in 8713108. Then take only the 5 numbers from the left (87131) and convert that from HEX2DEC resulting in 553265. I need this number (553265) in B2. Then the last two numbers of 8712108 (08), I need to convert from HEX2DEC and populate that result in C2 (8).

    Any help with these formulas in B2 and C2 would be much appreciated.

    A B C
    2 141635848 553265 8

  2. #2
    Board Regular bobsan42's Avatar
    Join Date
    Jul 2010
    Bulgaria, GMT+2 (42.891813,25.313594)
    Post Thanks / Like
    6 Post(s)
    0 Thread(s)

    Default Re: Help with Complex Formulas

    B2: =hex2dec(left(dec2hex(f11),5))
    c2: =hex2dec(right(dec2hex(f12),2))
    "'s sad that in our blindness we gather thorns for flowers..."
    mostly using:
    windows 7 +10 (64-bit) / excel 2013 +2016 (32-bit) / access 2013 +2016 (32-bit) / some imagination & Google of course
    You don't need to read between the lines - just read them all!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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