第1个回答 2013-02-15
=BIN2DEC(MID(A1,1,9))*512^3+BIN2DEC(MID(A1,10,9))*512^2+BIN2DEC(MID(A1,19,9))*512+BIN2DEC(MID(A1,28,9))
不过只能显示36位二进制数转十进制数;36位二进制放于A1格内,B1格输入此公式;连等号一起复制;以下是68719476735以下十进制转二进制数,且显示36位二进制数EXCEL2007公式;
=TEXT(DEC2BIN(MOD(INT(A1/512/512/512),512)),"000000000")&TEXT(DEC2BIN(MOD(INT(A1/512/512),512)),"000000000")&TEXT(DEC2BIN(MOD(INT(A1/512),512)),"000000000")&TEXT(DEC2BIN(MOD(A1,512)),"000000000")
这是68719476735以下的十进制数转36位二进制数公式;十进制数放于A1格内,B1格内输入此公式;也连等号一起复制;68719476735以上的十进制数不能用此公式;
以下是两个36位二进制数异或公式:(两个二进制数分别放于A1和B1格,C1格输入此公式)
=SUBSTITUTE(TEXT(MID(A1,1,15)+MID(B1,1,15),"000000000000000"),2,0)&SUBSTITUTE(TEXT(MID(A1,16,15)+MID(B1,16,15),"000000000000000"),2,0)&SUBSTITUTE(TEXT(MID(A1,31,6)+MID(B1,31,6),"000000"),2,0)