Problem 5

Problem 5
Decimal to Binary	1234	=IF(B2="","",TEXT(DEC2BIN(INT(B2/512)),"0;;")&DEC2BIN(MOD(B2,512),MIN(9,LOG(B2,2)+1)))
ANSWER: 10011010010
Decimal to Hexadecimal	1234	=DEC2HEX(B3/(16^9))&DEC2HEX(MOD(B3,16^9))
ANSWER: 4D2

Binary to Decimal	1100101	=SUMPRODUCT(--MID(B5,LEN(B5)+1-ROW(INDIRECT("1:"&LEN(B5))),1),(2^(ROW(INDIRECT("1:"&LEN(B5)))-1)))	ANSWER: 101
Binary to Hexadecimal	1100101	=IF(LEN(B6)>8, BIN2HEX(LEFT(B6, LEN(B6)-8)), "") & RIGHT("00" & BIN2HEX(RIGHT(B6, 8)), 2)
ANSWER: 65


Hexadecimal to Binary	ABC	=HEX2BIN(LEFT(B9,LEN(B9)-2))&HEX2BIN(RIGHT(B9,2),8)
ANSWER: 101010111100
Hexadecimal to Decimal	ABC	=HEX2DEC(B10) - 65536*AND(LEN(B10)=4,HEX2DEC(LEFT(B10,1))>=8)
ANSWER: 2748