Hexadecimal Checksum

[Scottabray]

I have 5 cells with a Hexadecimal in it, on the 6th cell, I would like to have a Hexadecimal checksum. I have tried this:

=dec2hex(hex2dec(H8))+(hex2dec(I8))+(hex2dec(J8))+(hex2dec(K8))+(hex2dec(L8))

but it doesn't work, any help or pointers would be greatly appreciated!!!!

Thanks!!!

Scott

 

[mikerickson]

What do you mean "doesn't work"?

Are the entries in H8:L8 have a preceeding $ (e.g. $34af).
Do those cells have an intermediate space (e.g. 0010 002A)

If there are superflous characters, they should be removed before using HEX2DEC
e.g. HEX2DEC(SUBSTITUTE(SUBSTITUTE(A1, " ", ""), "$", ""))

Is the sum greater than the limit of DEC2HEX?

 

[Scottabray]

This excel sheet is actually doing quite a bit, and this is the last part of it.

For example, I have the following serial string inserted in a cell:
(02, 8C, 00, 00, 00, 1B, 83, 8F, 03)
From there I have a bunch of hidden cells that parse that string out into individual columns and also does a find & replace (i.e. 1B, 83, = 03), the original checksum in this serial string is (8F), but due to substitutions (1B, 83, = 03) that checksum is no longer valid.

My entire progression of entries is as follows:

(P8) Insert String
(X8) =SUBSTITUTE(P8,"1B, 82","02")
(Y8) =SUBSTITUTE(X8,"1B, 83","03")
(Z8) =SUBSTITUTE(Y8,"1B, 86","06")
(AA8) =SUBSTITUTE(Z8,"1B, 95","15")
(AB8) =SUBSTITUTE(AA8,"1B, 9B","1B")
(G8) =IF(ISBLANK(P8),"",SUBSTITUTE(LEFT(AB8,SEARCH(" ",AB8,1)),",",""))
(H8) =IF(ISBLANK(P8),"",SUBSTITUTE(MID(AB8,SEARCH(" ",AB8,1)+1,SEARCH(" ",AB8,SEARCH(" ",AB8,1)+1)-SEARCH(" ",AB8,1)),",",""))
(I8) =IF(ISBLANK(P8),"",SUBSTITUTE(MID(AB8,SEARCH(" ",AB8,1)+5,SEARCH(" ",AB8,SEARCH(" ",AB8,1)+2)-SEARCH(" ",AB8,1)),",",""))
(J8) =IF(ISBLANK(P8),"",SUBSTITUTE(MID(AB8,SEARCH(" ",AB8,1)+9,SEARCH(" ",AB8,SEARCH(" ",AB8,1)+1)-SEARCH(" ",AB8,1)),",",""))
(K8) =IF(ISBLANK(P8),"",SUBSTITUTE(MID(AB8,SEARCH(" ",AB8,1)+13,SEARCH(" ",AB8,SEARCH(" ",AB8,1)+1)-SEARCH(" ",AB8,1)),",",""))
(L8) =IF(ISBLANK(P8),"",SUBSTITUTE(MID(AB8,SEARCH(" ",AB8,1)+17,SEARCH(" ",AB8,SEARCH(" ",AB8,1)+1)-SEARCH(" ",AB8,1)),",",""))
(M8) =IF(ISBLANK(P8),"",SUBSTITUTE(MID(AB8,SEARCH(" ",AB8,1)+21,SEARCH(" ",AB8,SEARCH(" ",AB8,1)+1)-SEARCH(" ",AB8,1)),",",""))
(N8) =IF(ISBLANK(P8),"",MID(AB8,SEARCH(" ",AB8,1)+25,SEARCH(" ",AB8,SEARCH(" ",AB8,1)+1)-SEARCH(" ",AB8,1)))

Cell M8 is the one that is the CheckSum cell, and the one that I would have to sum cells H8:L8.

Hope this wasn't too much, but I'm kind of a noob on excel formulas and this sheet has been a work in progress for about 1.5 years.

I really appreciate any direction that can be given.

Scott