ReferenceFunctionsEngineering Functions
BIN2OCT
BIN2OCT: Converts a binary text value to octal text.
Summary
Supports optional left-padding through the places argument.
Remarks
- Input must be binary text up to 10 digits and may be signed two's-complement.
- Signed values are preserved through conversion to octal.
placesmust be at least the output width and at most10, or#NUM!is returned.
Examples
Convert binary to octal
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
77
Pad octal output
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
0077
Related functions
FAQ
How are signed 10-bit binaries handled by BIN2OCT?
They are first decoded as signed decimal and then re-encoded to octal with two's-complement output for negatives.
Runtime metadata
Category
Engineering
Signature
BIN2OCT(arg1: Number, arg2…: Number)Arity
min 1, max variadic
Arguments
arg1Number · Scalar · coercion NumberLenientText
arg2Number · Scalar · coercion NumberLenientText
Caps
PURE
Source