How to Use Excel BIN2DEC Function?

Ads

Excel is a spreadsheet program that is developed for Windows, Mac, Android, and iOS. It helps to perform calculations on your PC. The purpose of this software is to do complicated calculations which are difficult to do manually. With the help of this spreadsheet program, you can insert, organize, maintain, manage, and calculate data.

In this article, we will see how to use BIN2DEC Function in Excel. This function will convert Binary numbers to Decimal values. Let’s get into this article to explore the syntax, definition, and Examples. Get the official version of MS Excel from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel.

Definition of BIN2DEC Function

The BIN2DEC function is one of the built-in functions in Excel.
This Function is mainly used for Binary to Decimal Conversion.
The input numbers must contain only ten characters, and else it will return #NUM! Error.

Syntax

Here, you will see the syntax of the BIN2DEC function.
To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
Once you enter the formula, just click on the Enter button to get the result.

=BIN2DEC (number)

Argument Explanation

Number – Give the binary number that you want to convert to a decimal number. But it should contain only ten characters. You can use positive or negative integers. We can represent negative numbers in 2’s complement notation.

Note:
1) If the input number contains more than ten digits, it will display the #NUM! Error.
2) If the input value is an invalid binary number (other than zeros and ones), it may show the #NUM! Error.

Examples

Let’s see some examples to know how to use the BIN2DEC function in Microsoft Excel.

Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
The first bit of the binary number shows whether it is a positive number or a negative number.
If the binary value starts at 0, it is a positive number. In the following image, we have shown you some positive decimal numbers for your reference in a range.

Now, we need to enter the above-mentioned formula to get the result.

After entering the formula, you need to click the Enter button to get the output, as shown below. To fill the remaining cells, you just need to drag down the first cell.

Note:
If you give less than nine digits as binary values, it will assign Zeros automatically to the beginning of the number. Then only it will return the corresponding Decimal Value.

Let’s see another example to make it clear how this function works with negative binary values. If the Binary value starts at 1, it will be a negative value.
The following screenshot has shown Binary to decimal conversion using a negative number.
You have to enter the formula in the cell as shown below to get the result.

After entering the formula, you need to click the Enter button to get the output, as shown below.

Input that Causes Error

If the input number contains more than ten digits, it will display the #NUM! Error.
If the input value is an invalid binary number (other than zeros and ones), it may show the #NUM! Error.

Verdict

The above article helped you to know how to use the BIN2DEC Function with examples. Leave your feedback in the comment section. To learn more about Excel functions, then visit our webpage Aawexcel.com.