BIN2DEC

• How to use BIN2DEC formula?
• Examples of using BIN2DEC formula
• BIN2DEC formula not working?
• Similar formulas to BIN2DEC

Usage

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

=BIN2DEC(signed_binary_number)

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

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

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.

Related Formulas

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.