How to use the DEC2BIN function
Author: Oscar Cronquist Article last updated on May 11, 2022
The DEC2BIN function converts a decimal number to a binary number.
Formula in cell D3:
=DEC2BIN(B3,C3)
Excel Function Syntax
DEC2BIN(number, [places])
Arguments
number | Required. The decimal integer you want to convert. |
[places] | Optional. The number of characters to use. If not entered the function uses the number of characters needed to complete the task. This argument allows you to add leading 0s (zeros). |
Functions in 'Engineering' category
The DEC2BIN function function is one of many functions in the 'Engineering' category.
Converts a binary number to the decimal number system.
Converts a binary number to hexadecimal.
Converts a binary number to octal.
Calculates a bitwise 'AND' of two numbers.
Calculates a number whose binary representation is shifted left by a specified number of bits.
Performs a bitwise 'OR' of two numbers.
Calculates the number where the binary equivalent is shifted right by a specified number of bits and then converted back to a number.
Calculates a decimal number that is a result of a bitwise comparison "XOR" of two numbers.
Returns a complex number based on a real and imaginary number.
Converts a number from one measurement system to another.
Converts a decimal number to a binary number.
Converts a decimal number to a hexadecimal number.
Converts a decimal number to an octal number.
Evaluates whether two numerical values are equal.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form