BIN2DEC Function in Google Sheets

Convert a binary number to a decimal number using the BIN2DEC function.

BIN2DEC Function

The BIN2DEC function in Google Sheets converts a signed binary number to a decimal number.

Syntax

BIN2DEC(signed_binary_number)
  • signed_binary_number: The binary number to be converted.

Examples

  1. Basic Conversion

To convert the binary number 1010 to decimal:

=BIN2DEC("1010")
  1. Negative Binary Number

Converting the signed binary number 1111111110 to decimal:

=BIN2DEC("1111111110")

Notes

  • The input must be a valid binary number, containing only 0s and 1s.
  • The function supports both positive and negative binary numbers.
  • DEC2BIN: Converts a decimal number to a binary number.
  • BIN2HEX: Converts a binary number to a hexadecimal number.