Skip to main content
Version: Streamsheets 2.3

OCT2BIN

Converts an octal number to binary.

Syntax

=OCT2BIN(Number, [Places])

Arguments

NameDescription
NumberThe octal number to convert.
PlacesOptional. The number of characters to use for returned value. If value has less characters then it is padded with leading zeros.

Return Value

The binary number or a #NUM! error if given number is not a valid octal number. The #VALUE! error is returned if specified places is nonnumeric or negative.

Example

FunctionResultComment
=OCT2BIN(3)11converts octal 3 to binary
=OCT2BIN(3, 4)0011converts octal 3 to binary with 4 characters