bin2dec在excel中的数字超过10位 [英] bin2dec for numbers longer than 10 bits in excel

问题描述

我有一个excel与28位二进制数字。我需要将它们转换成十进制数，但是函数bin2dec不能使用长于10位的数字。任何人都可以帮助我吗？

解决方案

使用以下公式来模拟一个

I have an excel with 28 position binary numbers. I need to convert them to decimal numbers, but function bin2dec don't work with numbers longer than 10 bits. Can anyone help me with this?

解决方案

Use the following formula to mimic a BIN2DEC function that coverts larger than 10 bits.

=SUMPRODUCT(--MID(A2,LEN(A2)+1-ROW(INDIRECT("1:"&LEN(A2))),1),(2^(ROW(INDIRECT("1:"&LEN(A2)))-1)))

Remember that Excel has a numerical precision of 15 digits. If you want 28 digits, format the cell as Text or preface the string of digits with a single tick (e.g. ') as a PrefixCharacter property.

   

这篇关于bin2dec在excel中的数字超过10位的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！