Check Sheet Logo
Check Sheet

BIN2DEC

The BIN2DEC formula is an engineering formula used to convert a signed binary number to a decimal number. This formula is commonly used in computer science and engineering fields.

Usage

Use the BIN2DEC formula with the syntax shown below, it has 1 required parameter:

=BIN2DEC(signed_binary_number)
Parameters:
  1. signed_binary_number (required):
    The signed binary number that you want to convert to decimal. This must be a string that contains no more than 10 characters. The leftmost character is the sign bit, with 0 indicating a positive number and 1 indicating a negative number.

Examples

Here are a few example use cases that explain how to use the BIN2DEC formula in Google Sheets.

Converting binary numbers to decimal

You can use the BIN2DEC formula to convert binary numbers to decimal. This is useful for working with binary data in engineering and computer science applications.

Working with signed binary numbers

The BIN2DEC formula is particularly useful for working with signed binary numbers, which are commonly used in computer science and engineering applications.

Common Mistakes

BIN2DEC not working? Here are some common mistakes people make when using the BIN2DEC Google Sheets Formula:

Invalid binary number

The input must be a valid signed binary number. Make sure the input contains only 0s and 1s and starts with a minus sign (-) if it is negative.

Missing argument

The BIN2DEC function requires one argument. Make sure you are providing a valid signed binary number as input.

Invalid data type

The input must be a valid signed binary number. Make sure the input is formatted as text or a number.

Negative exponent

If the input contains a negative exponent, the result may be inaccurate. Consider using a different formula for converting binary to decimal in this case.

Overflow error

If the input is too large, the function may return an error or an incorrect result. Consider using a different formula or breaking the input into smaller chunks.

The following functions are similar to BIN2DEC or are often used with it in a formula:

  • DEC2BIN

    The DEC2BIN formula is used to convert a decimal number to a binary number. This is commonly used in engineering and computer science to represent numbers in their binary form. The formula takes in a decimal number and an optional number of significant digits to include in the binary representation.

  • HEX2DEC

    The HEX2DEC function converts a signed hexadecimal number to its decimal equivalent. This function is commonly used in engineering calculations where hexadecimal numbers are used to represent signed values.

  • OCT2DEC

    The OCT2DEC function converts a signed octal number to its decimal equivalent. It takes one required parameter, the signed_octal_number, which is the signed octal number you want to convert to decimal. The function returns the decimal equivalent of the signed octal number.

Learn More

You can learn more about the BIN2DEC Google Sheets function on Google Support.