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 DEC2OCT and OCT2DEC FUNCTIONS which help us to convert the Decimal numbers to the OCTAL number .
We’ll also learn the reverse process which will enable us to convert OCTAL 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 OCTAL NUMBER SYSTEM?
As DECIMAL NUMBER SYSTEM contains TEN DIGITS, we have a OCTAL NUMBER SYSTEM where we have got just EIGHT DIGITS right from the 0 up to 7.
It means , the counting in the octal system goes like
0, 1, 2, 3, 4, 5, 6, 7, 10,12,13…..and so on.
WHY TO CONVERT THE DECIMAL SYSTEM INTO OCTAL SYSTEM?
Every number system was developed through the history for some specific reasons.
OCTAL SYSTEM can be represented using the THREE BITS only and is very easy to convert to and from binary system.
TEMPLATE TO CONVERT ANY NUMBER FROM OCTAL TO DECIMAL AND DECIMAL TO OCTAL
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 OCTAL 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 are 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 OCTAL NUMBER
- Open the template.
- Enter the number to be converted from DECIMAL to OCTAL in the Designated field.
- As we input the number , the result will instantly be shown in the result field.
STEPS TO CONVERT OCTAL NUMBER TO DECIMAL NUMBER
- Open the template.
- Enter the number to be converted from OCTAL to DECIMAL in the Designated field.
- As we input the number , the result will instantly be shown in the result field.
EXAMPLE 1:
CONVERT 1144 DECIMAL NUMBER [ NORMAL COUNT] INTO OCTAL SYSTEM.
SOLUTION
- Simply open the template
- Enter the 1144 in the ENTER DECIMAL NUMBER field in the yellow color.
- As, we enter the 1144 , the result will appear as 2170.
This was the way to convert a decimal number to OCTAL NUMBER.
EXAMPLE 2
CONVERT 452 OCTAL NUMBER INTO DECIMAL [ NORMAL ] NUMBER
SOLUTION
- Simply open the template
- Enter the 452 in the ENTER OCTAL NUMBER field in the yellow color.
- As, we enter the 452 , the result will appear as 298.
HOW THE TEMPLATE WORKS?
The template simply makes use of the TWO AVAILABLE FUNCTION , DEC2OCT and OCT2DEC to get the output in the template.
So, in this article, we used a template to convert OCTAL number to decimal or decimal number to OCTAL instantly.