Help with Complex Formulas

[tbruce]

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.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]VALUE[/TD]
[TD="align: center"]PAC[/TD]
[TD="align: center"]PID[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]141635848[/TD]
[TD]553265[/TD]
[TD]8[/TD]
[/TR]
</tbody>[/TABLE]

 

[bobsan42]

B2: =hex2dec(left(dec2hex(f11),5))
c2: =hex2dec(right(dec2hex(f12),2))