View original (French)

Excel and Hex Calculations

Solved
alex -  
 #NOM ? -
A small question.
Is it possible to create hexadecimal spreadsheets in Excel? Without going through a conversion: hex -> decimal, calculations then the result of the calculation in decimal -> conversion back to hexadecimal (with dechex and hexdec)

basically doing all calculations in hex
like:
column 1 = FF1
column 2 = A2
Column 3 = column 1 + column 2 = result in hex.

thank you

1 answer

  1.
    piopicolo Posted messages 1422 Status Member 200
     
    Don't think! The letters are processed as text. So your hex numbers will be treated as text.
    That's just my opinion... See you and it will be fine!
    0
    1. alex
       
      sniff... too bad. I thought I'd impress everyone by finding out how to do it... ;)
      It's okay.

      Thanks anyway.

      alex
      0
    2. Ashmodee Posted messages 1 Status Member 2
       
      Hi, very late but this could still be useful for someone who comes across this topic while searching.
      Here is a formula to perform a hexadecimal calculation in Excel with on-the-fly conversion: 

      =DECHEX(HEXDEC(**)+HEXDEC(**))

      replace the ** with the cell names.
      2
    3. #NOM ?
       
      If you get the result #NAME?

      You need to enable the analysis tools from the “Add-ins” menu.
      Otherwise, it won’t work.
      0