DEC2BIN

Converts decimal number to binary.

Excel: Verified match
Google Sheets: Verified match
Returns: Text

Examples

=DEC2BIN(9, 4)

Result 1001

Syntax

DEC2BIN(number, [places])

number: number required
places: number optional defaults to 1

BESSELIReturns modified Bessel function In(x). BESSELJReturns Bessel function Jn(x). BESSELKReturns modified Bessel function Kn(x). BESSELYReturns Bessel function Yn(x). BIN2DECConverts binary number to decimal. BIN2HEXConverts binary number to hexadecimal.