BIN2DEC

Formulas / BIN2DEC
Convert a binary number to decimal.
=BIN2DEC(number)
  • number - the binary number to convert

Examples

  • =BIN2DEC(1100100)

    This function can be used to convert binary numbers to decimal numbers. For example, will convert the binary number 1100100 to the decimal number 100.

  • =BIN2DEC(1111111111)

    This example will convert the binary number 1111111111 to the decimal number 1023.


Summary

The BIN2DEC function is used to convert a binary number, up to 10 bits, into its decimal equivalent. It takes a binary number as an argument and returns its decimal value, or #NUM! if the binary number is not valid.

  • The BIN2DEC function converts a binary number to decimal.
  • The input number must be less than 10 characters long and can only contain zeros and ones.
  • An error of #NUM! will be returned if the input is not valid.

Frequently Asked Questions

What does the BIN2DEC function do?
The BIN2DEC function converts a binary number to decimal.
What argument does the BIN2DEC function take?
The BIN2DEC function takes a binary number as its argument.
What is the format of the binary number?
The binary number must be a binary number.
What is the maximum length of the binary number?
The binary number cannot have more than 10 characters.
What error does the BIN2DEC function throw if the binary number does not convert to a decimal number?
The BIN2DEC function throws a #NUM! error if the binary number does not convert to a decimal number.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV