DEC2BIN
Formulas / DEC2BINConvert decimal numbers to binary.
=DEC2BIN(number,[places])
- number - required, decimal integer to convert
- places - [OPTIONAL] number of characters to use
Examples
The DEC2BIN function converts decimal 9 to binary with 4 characters. The output of this function is 1001.
The DEC2BIN function converts decimal -100 to binary. The result of this function is 11001011.
Need help with Formulas?
Summary
The DEC2BIN function is a useful tool for converting a decimal integer into its binary format. It is a quick and efficient way to convert a decimal number into its binary form.
- The DEC2BIN function converts a decimal number to its binary equivalent, returning a binary number.
- The DEC2BIN function only takes one required argument, the decimal number to convert.
- The places argument is optional and pads the resulting binary number with zeros to the specified number of digits.
Frequently Asked Questions
What is the DEC2BIN function?
The DEC2BIN function is a mathematical function used to convert a decimal number to binary format.
What does the DEC2BIN function take as an argument?
The DEC2BIN function takes a decimal integer as its argument.
Is the decimal integer to convert required?
Yes, the decimal integer to convert is required.
What format does the DEC2BIN function convert a decimal number to?
The DEC2BIN function converts a decimal number to binary format.
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.
Drop CSV