Advanced BIN2HEX Question

[compmajor]

I need to create a formula that converts an 8-bit binary number to hexidecmal while ignoring the most significant bit. For example, I have a cell where I enter an interger, 224, let's say. I conver that to binary in the cell below using the DEC2BIN(Cell#, 8) formula. Now, in the cell below that I need to convert the binary to hex, but ignore the most significant bit. So if 224 becomes 11100000, I need the hex to be 30 instead of E0. Help!

 

[patrickmuldoon99]

Been a while since i did my Comp Science course, but am I right in assuming that in the binary number 11100000, the left most 1 is the most significant bit (i.e. with the highest translated value)?

If so, this formula should work for you presuming you have the binary number in cell A1

=BIN2HEX(RIGHT(A1,7))

However, this returns 60 and not 30.

Patrick

 

[northwolves]

1110000 of Binary base is 112 of decimer base,not 224

 

[patrickmuldoon99]

An improved attempt:

=IF(ISERROR((BIN2HEX(RIGHT(A1,(LEN(A1)-FIND("1",A1,1)))))),"Invalid",(BIN2HEX(RIGHT(A1,(LEN(A1)-FIND("1",A1,1))))))

Again, assuming A1 is the cell with the 8-bit binary representation, this will search for the first instance of a 1 to locate the MSB from left to right, and remove that from the calculation.


edit: northwolves, you have missed a zero, which is why you are getting the incorrect decimal conversion.

 

[northwolves]

=DEC2HEX(MOD(224,128))

 

[Richard Schollar]

Hi

Maybe:

=BIN2HEX(REPLACE(A1,1,1,"0"))

Best regards

Richard

 

[barry houdini]

I need to create a formula that converts an 8-bit binary number to hexidecmal while ignoring the most significant bit. For example, I have a cell where I enter an interger, 224, let's say. I conver that to binary in the cell below using the DEC2BIN(Cell#, 8) formula. Now, in the cell below that I need to convert the binary to hex, but ignore the most significant bit. So if 224 becomes 11100000, I need the hex to be 30 instead of E0. Help!

So if A1 contains, say, 54. You convert this to binary in A2 resulting in

00110110

ignoring the most significant bit this becomes

00010110

converted to a hex number = 16

If this is what you mean then you could do this without reference to the binary number, i.e. using this formula where A1 contains your initial decimal number

=DEC2HEX(A1-2^FLOOR(LOG(A1,2),1))

....alternatively....by referencing your binary number in A2.....

=BIN2HEX(SUBSTITUTE(A2,1,0,1))