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))