Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/myscript/public_html/classes/classdb.php on line 42 Bin2Dec Function / Formula in Microsoft Excel 2007 | Video Tutorial
The Bin2dec function is used to convert a binary number to a decimal number.
=BIN2DEC(C4) Where C4 is the value mentioned in the cell C4. Note that the function returns #NUM! error value if the given number is not a binary number. It also shows the same error message if the number has more than 10 digits. Negative numbers are represented using two's-complement notations.
Let us learn to convert binary numbers to decimals, using BIN2DEC function, through the below video.