Skip to main content
Version: Streamsheets 3.0

OCT.TO.BIN

Converts an octal number to binary.

Syntax

=OCT.TO.BIN(Number, [Places])

Arguments

NameTypeDescription
NumberNumberThe octal number to convert.
Places (optional)NumberThe number of characters to use for returned value. If value has less characters then it is padded with leading zeros.

Return

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

Examples

FormulaResultComment
=OCT.TO.BIN(3)
11converts octal 3 to binary
=OCT.TO.BIN(3, 4)
0011converts octal 3 to binary with 4 characters