I have given here about formula syntax and usage of the BIN2DEC function in Microsoft Excel.
Converts a binary number to decimal.
The BIN2DEC function syntax has the following arguments:
Number Required. The binary number you want to convert. Number cannot contain more than 10 characters (10 bits). The most significant bit of number is the sign bit. The remaining 9 bits are magnitude bits. Negative numbers are represented using two's-complement notation.
If number is not a valid binary number, or if number contains more than 10 characters (10 bits), BIN2DEC returns the #NUM! error value.
How to find the decimal number for given binary number “11100”?
Type the function as follows in the cell that you would like to get the result in:
Note: I have given some other functions below to help you to workout more on converting numbers functional as MS-Excel has been providing them. When you want to execute those functions in Worksheet, you can feel freely follow the way as same as I have given an example for this "BIN2DEC" function in this tutorials.
For more understanding, look at the screenshot please: