A negative binary number is expected to use the two’s complement notation.
Related functions
DEC2BIN Function
BIN2DEC Function
The Excel BIN2DEC function converts a binary number to the decimal equivalent. The input number must contain only zeros and ones and be less than 10 characters long, otherwise the function returns the #NUM! error value.
