DEC2BIN Excel Formula
When we point out about Microsoft Excel, the first adjective that comes to anyone’s mind is saving, managing and organizing data or figures. This is definitely true. Microsoft Excel is an excellent way to create and formulate any database. Here, information are arrange in a table form. But with regards to the program, it is essential to know its function to make it very useful particularly for engineering computation. One of the functions of Excel that you need to be familiar with is the DEC2BIN. What is DEC2Bin function? How it is use in Excel?
What is DEC2BIN Function?
The function changes decimal number to its equivalent binary value. This is a very essential function particularly in programming since the machine language is done in binary; however, majority of the people utilize the decimal system.
Formula Information
The formula of DEC2BIN is written as =DEC2BIN(number, places). With this, the number is equal to the decimal integer you like to change. Once the number is in negative form, valid place values are neglected and the DEC2Bin result goes back to 10 character binary figure in which most of the essential bit is identified as sign bit. The left behind 9 characters are called as magnitude bits. Numbers in negative forms are represented utilizing two complement notations.
Additionally, the places in the formula are number of the bits to use. Once the place has no written value, DEC2BIN function utilizes the least number of significant characters. Places are valuable for padding the value returned with leading 0s.
Things Needed to Know About the Function:
- Once the value is less than -512 or the number is greater than 511, the outcome is #NUM error.
- #VALUE error comes out, once the number is not numeric.
- #NUM error could also appear once the function needs greater characters places.
- The function is truncated, once the places are not integer.
- #NUM error also comes out once the places has negative or zero value.
To avoid errors in DEC2BIN function and formula, input value should be correct, allowed and accepted by Excel program since there are values or characters that Excel could not read. Once an error value appears, check the type in formula. Aside from the formula, make sure that the program needed in using the function is enabled from the worksheet you are running.
How to Use DEC2BIN Function:
Below are the basic examples of DEC2BIN function.
=DEC2BIN(2) – 10 – Result is 1*2 + 0
=DEC2BIN( 2, 10 ) – 0000000010 – Result is equal to 1*2 + 0
=DEC2BIN( -2 ) – 1111111110 – Outcome is Result is -2^9 + 2^8 + 2^7 + … + 2 + 0
=DEC2BIN( 6 ) – 110 – Answer is 2^2 + 2 + 0
In using DEC2BIN, the user must learn the formula and the common error associated to ensure of obtaining the correct result. Moreover, any person should be familiar on how the function is being analyzed. Inputting the correct formula, you can type in and acquire 100 percent correct answer. Study the example written above and learn how the function is used.
Further readings
Post comment
Categories
Recent Posts
- How to Use the MS Excel Keyboard Shortcuts
- How to Locate Duplicate Records Quickly By Using Conditional Formatting in MS Excel
- How to Use PasteSpecial – Procedures for Microsoft Excel 2003 and Microsoft Excel 2007
- How to Sort using an AutoFilter – Understanding and Learning the Feature
- How to Base a Chart Off of Auto Filtered Records
- How to Use IF IsError Together?
- How to Use Custom Views
- How to Create Pivt Table
- How to Manipulate PivotTable after It has Been Created
- How to Update the Data in a Pivot Table
- How to Create Dynamic Named Ranges
- How to Use an Array
- How to Embed 8 If Statements into 1
- How to Edit a Recorded Macro?
- How to Record a Macro