Google Sheets-funktion

DEC2BIN

Converts a decimal number to binary.

Skapa en formel med AI Samma funktion i Excel

Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.

Syntax

DEC2BIN(number, [places])

The DEC2BIN function takes a decimal integer and returns its binary equivalent as a text string. If the number is negative, the function returns a 10-character two's complement binary number.

Argument

numberobligatorisktThe decimal integer to convert, ranging from -512 to 511.
placesvalfrittThe number of characters to use; if omitted, the minimum number of characters is used.

Exempel

=DEC2BIN(10)

Resultat: 1010

Converts the decimal number 10 to its binary representation.

=DEC2BIN(5, 8)

Resultat: 00000101

Converts 5 to binary with a fixed length of 8 characters.

Vanliga frågor

What is the maximum value I can convert?

The function supports decimal integers from -512 to 511.

Relaterade funktioner

BIN2DEC DEC2HEX DEC2OCT