ReferenceFunctionsEngineering Functions
OCT2BIN
OCT2BIN: Converts an octal text value to binary text.
Summary
Supports optional left-padding through the places argument.
Remarks
- Input must be octal text up to 10 digits and may be signed two's-complement.
- Converted values must fall in
[-512, 511], or the function returns#NUM!. placesmust be at least the output width and at most10, or#NUM!is returned.
Examples
Convert octal to binary
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
111111
Convert signed octal
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
1111111111
Related functions
FAQ
Why does OCT2BIN return #NUM! for some octal inputs?
After decoding, the value must be within [-512, 511] to be representable in Excel-style binary output.
Runtime metadata
Category
Engineering
Signature
OCT2BIN(arg1: Number, arg2…: Number)Arity
min 1, max variadic
Arguments
arg1Number · Scalar · coercion NumberLenientText
arg2Number · Scalar · coercion NumberLenientText
Caps
PURE
Source