Excel Function : DEC2BIN
Category
Engineering
Description
Converts a decimal number to binary
Microsoft Excel Reference Page
https://support.office.com/en-us/article/DEC2BIN-function-0f63dd0e-5d1a-42d8-b511-5bf5c6d43838
Syntax and Description of the DEC2BIN Excel Function
I am trying to convert a decimal number to a binary number in excel using the DEC2BIN function.
However, I am getting a syntax error that says "too few arguments."
What is the correct syntax for this function?
A:
The syntax of DEC2BIN
is =DEC2BIN(decimal_number, [number_of_bits])
where decimal_number
is a decimal number between -512 and 511 and number_of_bits
is an optional argument between 1 and 10.
You have left out the decimal_number
About DEC2BIN Excel Function
The DEC2BIN function converts a decimal number to binary.
The number must be between -512 and 511.
The number can be entered as a decimal, hexadecimal, octal, or binary number.
The number can also be a cell reference.