INTRODUCTION
Google Sheets is the spreadsheet application offered by Google.
Spreadsheet applications are very helpful in different types of mathematical applications.
The functions present in the Google Sheets are useful in the different areas of the work. These functions are categorized as per their genre.
For Example,
There are Text functions, time functions, array function, statistical functions, mathematical functions, engineering functions and so on.
In this article, we’ll focus on one of the ENGINEERING FUNCTION and the function is known as DEC2BINARY FUNCTION which help us to convert the Decimal numbers to the binary number .
We’ll also learn the reverse process which will enable us to convert BINARY NUMBER TO DECIMAL NUMBER with the help of the given template.
WHAT IS A DECIMAL NUMBER SYSTEM ?
1,2,3,4…0 are the normal numerals which we all know.
Actually these are the ARABIC NUMERALS.
We can see that we have 10 numbers in this system and all the other numbers are made from these numbers.
So, when we are having the ten numbers in a system , we call it a decimal system. [ DECA – 10 ]
Similar to a DECIMAL system, we have got many systems like BINARY, OCTAL, HEXADECIMAL and so on.
WHAT IS A BINARY NUMBER SYSTEM?
As DECIMAL NUMBER SYSTEM contains TEN DIGITS, we have a BINARY NUMBER SYSTEM where we have got just two digits which are 0 and 1.
The counting goes something like
0
01
10
11
WHY TO CONVERT THE DECIMAL SYSTEM INTO BINARY SYSTEM?
Every number system was developed through the history for some specific reasons.
BINARY SYSTEM HAS GOT THE IMPORTANCE IN THE DIGITAL WORLD. THE DIGITAL DEVICES RESPOND TO THE TWO VOLTAGE LEVELS ONLY WHICH REPRESENT THE OUTCOME AS A 0 OR 1.
SO, BINARY SYSTEM PROVIDES US THE EASE TO CALCULATE THE OUTCOMES AND HELP IN DESIGNING OF THE DIGITAL DEVICES.
All the calculations can be done using the binary mathematics but WE ARE ACQUAINTED TO USE DECIMAL MATHEMATICS which is comparitively easier to understand.
As you can see
3 is written as 11 in Binary system.
This is easier and can be learnt but what if the binary number is 101011100101.
This one is not easier for us to understand but for the machines, this is the best.
So , the conclusion is WE NEED THE UNDERSTANDING OF THE BINARY MATHEMATICS FOR THE DIGITAL ELECTRONICS, whereas we need the DECIMAL NUMBER FOR OUR EASY UNDERSTANDING.
This is the reason why we need the conversion from DECIMAL TO BINARY and BINARY TO DECIMAL.
TEMPLATE TO CONVERT ANY NUMBER FROM BINARY TO DECIMAL AND DECIMAL TO BINARY
CLICK HERE TO GET YOUR COPY OF THIS CONVERTER.
- As you click on the link above, the Google Sheets will ask you to CREATE A COPY OF THE FILE FOR YOURSELF.
- Choose MAKE A COPY.
- This will open up in your GOOGLE SHEETS.
- [ If you are not logged in to Google Account, you’ll be asked to login. If you don’t have an account, you’ll be asked to create one. ]
- The CONVERTER SHEET is yours.
You can use it anytime.
The usage is given below.
STEPS TO CONVERT DECIMAL NUMBER TO BINARY NUMBER
In this tutorial we are going to learn the way with the help of GOOGLE SHEETS within the fraction of seconds.
The STEPS TO GET THE CONVERTER TEMPLATE is given here.
The user window is pretty simple as shown in the picture below.
USER INTERFACE
The left side fields shown in the yellow are the input fields.
The RIGHT SIDE contains the output or results.
STEPS TO CONVERT DECIMAL NUMBER TO BINARY NUMBER
- Open the template.
- Enter the number to be converted from DECIMAL to BINARY in the Designated field.
- As we input the number , the result will instantly be shown in the result field.
STEPS TO CONVERT BINARY NUMBER TO DECIMAL NUMBER
- Open the template.
- Enter the number to be converted from BINARY to DECIMAL in the Designated field.
- As we input the number , the result will instantly be shown in the result field.
EXAMPLE 1:
CONVERT 345 DECIMAL NUMBER [ NORMAL COUNT] INTO BINARY SYSTEM.
SOLUTION
- Simply open the template
- Enter the 345 in the ENTER DECIMAL NUMBER field in the yellow color.
- As, we enter the 345 , the result will appear as 101011001
This was the way to convert a decimal number to BINARY NUMBER.
EXAMPLE 2
CONVERT 11001101 BINARY NUMBER INTO DECIMAL [ NORMAL ] NUMBER
SOLUTION
- Simply open the template
- Enter the 11001101 in the ENTER BINARY NUMBER field in the yellow color.
- As, we enter the 11001101 , the result will appear as 205.
HOW THE TEMPLATE WORKS?
The template simply makes use of the TWO AVAILABLE FUNCTION , DEC2BIN and BIN2DEC to get the output in the template.
CLICK HERE TO LEARN DEC2BIN FUNCTION IN GOOGLE SHEETS. [ LINK WILL BE PROVIDED SOON ]
CLICK HERE TO LEARN BIN2DEC FUNCTION IN GOOGLE SHEETS. [ THE LINK WILL BE PROVIDED SOON ]
So, in this article, we used a template to convert binary number to decimal or decimal number to binary instantly.
