BIN2DEC(number)
- Where 'number' is the binary number to be converted to decimal number.
Description
BIN2DEC(number)
For example, BIN2DEC(101) returns 5 as a result.
BIN2DEC(11110) returns 30 as a result.
- BIN2DEC() converts a binary number to decimal number.
- Binaray number is represented using digits 1 or 0 only. The number can also be entered in text format (e.g "101").
- The conversion can be obtained for a binary number upto 10 bits. The most significant bit represents the 'sign' of the number (0=positive, 1=negative). Negative numbers are represented using 2's complement notation.
- Positive numbers can be from 0 (000000000) to 511 (0111111111) or negative numbers -1 (1111111111) to -512 (1000000000).
- A number preceding with '0' (e.g 01111111111) should be written in text format ("01111111111") to avoid confusion with octal numbers.
- A binary number (e.g '101') can be converted to decimal number (base 2) as -
(1*2^2)+(0*2^1)+(1*2^0)=4+0+1= 5
- If the number is not a valid number, 'Calci' returns an #ERROR message.
- Following function can be used to add two binary numbers and get the result in decimal -
SUM(BIN2DEC(100) + BIN2DEC(101)) that displays the result as 9.
Examples
| Binary Input | Decimal Output |
| 100 | 4 |
| 11110 | 30 |
| 1111111111 | -1 |
| 1111000000 | -64
|