How to Convert Binary to Decimal in Excel (2 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

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.


How to Convert Binary to Decimal in Excel: 2 Easy Methods

This is the dataset for today’s article. It has some binary numbers which I will convert to decimals.

dataset excel binary to decimal


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.

BIN2DEC function excel binary to decimal

  • Finally, use Fill Handle to AutoFill up to C10.

BIN2DEC function excel binary to decimal


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.

excel binary to decimal


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.

Download Practice Workbook

Download this workbook and practice while going through the article.


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.


<< Go Back to | Excel Number System Conversion | Excel for Math | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Akib Bin Rashid
Akib Bin Rashid

AKIB BIN RASHID, a materials and metallurgical engineer, is passionate about delving into Excel and VBA programming. To him, programming is a valuable time-saving tool for managing data, files, and internet-related tasks. Proficient in MS Office, AutoCAD, Excel, and VBA, he goes beyond the fundamentals. Holding a B.Sc in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, MD AKIB has transitioned into a content development role. Specializing in creating technical content centred around Excel and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo