Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. In this article, I will explain 2 easy methods in Excel for binary to decimal conversion.
Download Practice Workbook
Download this workbook and practice while going through the article.
2 Easy Methods to Convert Binary to Decimal in Excel
This is the dataset for today’s article. It has some binary numbers which I will convert to decimals.
1. Apply BIN2DEC Function to Convert Binary to Decimal in Excel
The first method is the use of the BIN2DEC function. This function will convert the binary numbers to decimal numbers.
Steps:
- Go to C5 and write down the following formula
=BIN2DEC(B5)
- Then, press ENTER to get the output.
- Finally, use Fill Handle to AutoFill up to C10.
Read More: How to Convert Decimal to Binary in Excel (3 Quick Methods)
2. Apply Combination of Functions to Convert Binary to Decimal in Excel
The following method is the use of a combination of multiple functions. These functions include the SUMPRODUCT, MID, LEN, ROW, and INDIRECT functions.
Steps:
- Go to C5 and write down the following formula
=SUMPRODUCT(--MID(B5,LEN(B5)+1-ROW(INDIRECT("1:"&LEN(B5))),1),(2^(ROW(INDIRECT("1:"&LEN(B5)))-1)))
Formula Breakdown
- LEN(B5)
- Output: 3
- “1:”&LEN(B5)
- Output: “1:3”
- ROW(INDIRECT(“1:”&LEN(B5)))
- Output: {1;2;3}
- (2^(ROW(INDIRECT(“1:”&LEN(B5)))-1))
- Output: {1;2;4}
- LEN(B5)+1-ROW(INDIRECT(“1:”&LEN(B5)))
- Output: {3;2;1}
- –MID(B5,LEN(B5)+1-ROW(INDIRECT(“1:”&LEN(B5))),1)
- Output: {1;1;1}
- =SUMPRODUCT(–MID(B5,LEN(B5)+1-ROW(INDIRECT(“1:”&LEN(B5))),1),(2^(ROW(INDIRECT(“1:”&LEN(B5)))-1)))
- Output: 7
- Then, press ENTER to get the output.
- After that, use Fill Handle to AutoFill up to C10.
Read More: How to Convert Hex to Decimal in Excel (2 Practical Examples)
Things to Remember
- Binary numbers contain only 2 digits, 0 and 1. Other digits are not applicable here. if you use digits other than 0 and 1, the results will not be accurate.
Conclusion
In this article, I have demonstrated 2 effective methods on how to convert binary numbers to decimal numbers in Excel. I hope it helps everyone. If you have any suggestions, ideas, or feedback, please feel free to comment below. Please visit Exceldemy for more valuable articles like this.