Bin2Dec Function

The Bin2dec function is used to convert a binary number to a decimal number.

Formula:


=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.

Video Tutorial:


Let us learn to convert binary numbers to decimals, using BIN2DEC function, through the below video.

Learn MS Excel


Ask Questions

Ask Question