Google Sheets-funktion

OCT2BIN

Converts an octal 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

OCT2BIN(number, [places])

The OCT2BIN function converts an octal number into its binary representation. If the optional places argument is provided, the function will pad the result with leading zeros to match the specified length.

Argument

numberobligatorisktThe octal number you want to convert, limited to 10 characters.
placesvalfrittThe number of characters to use in the output, useful for padding.

Exempel

=OCT2BIN(12)

Resultat: 1010

Converts the octal number 12 to the binary 1010.

=OCT2BIN(5, 4)

Resultat: 0101

Converts 5 to binary and pads it to 4 digits.

Vanliga frågor

What is the maximum value for the number argument?

The octal number cannot exceed 10 characters in length.

What happens if the result is longer than the specified places?

The function returns a #NUM! error.

Relaterade funktioner

BIN2OCT OCT2DEC DEC2BIN