BIN2DIC formula in MS Excel

	Binary Number	Decimal Equivalent
	0	#ADDIN?	=BIN2DEC(C4)
	1	1	=BIN2DEC(C5)
	10	2	=BIN2DEC(C6)
	11	3	=BIN2DEC(C7)
	111111111	511	=BIN2DEC(C8)
	1111111111	-1	=BIN2DEC(C9)
	1111111110	-2	=BIN2DEC(C10)
	1111111101	-3	=BIN2DEC(C11)
	1000000000	-512	=BIN2DEC(C12)
	11111111111	Err:502	=BIN2DEC(C13)
What Does It Do ?
This function converts a binary number to decimal.
Negative numbers are represented using two's-complement notation.
Syntax
=BIN2DEC(BinaryNumber)
The binary number has a limit of ten characters.
Formatting
No special formatting is needed.