Forum Discussion
Apr 19, 2024
Do you know how to convert binary numbers to decimal?
It's easy with the BIN2DEC function, but there's a limitation and an easy way to make a mistake and get a wrong result. The limitation is that it can't convert a number with more than 10 bits. If yo...
- Apr 25, 2024
I suspect DEC2BIN is now largely superseded by
= BASE(targetDec, 2) = DECIMAL(targetBin, 2)
PeterBartholomew1
Apr 25, 2024Silver Contributor
I suspect DEC2BIN is now largely superseded by
= BASE(targetDec, 2)
= DECIMAL(targetBin, 2)
Apr 25, 2024
PeterBartholomew1 - thank you for mentioning those. I had not used them before, but I agree with you.