Formualizer Docs
ReferenceFunctionsEngineering Functions

OCT2DEC

OCT2DEC: Converts an octal text value to decimal.

Summary

Supports up to 10 octal digits, including signed two's-complement values.

Remarks

  • Input is coerced to text and must contain only digits 0 through 7.
  • 10-digit values beginning with 4-7 are interpreted as signed 30-bit numbers.
  • Returns #NUM! for invalid characters or inputs longer than 10 digits.

Examples

Convert positive octal
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
15
Interpret signed 30-bit octal
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
-1

FAQ

How does OCT2DEC interpret 10-digit values starting with 4-7?

Those are treated as signed 30-bit two's-complement octal values.

Runtime metadata

Category

Engineering

Signature

OCT2DEC(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

crates/formualizer-eval/src/builtins/engineering.rs

OCT2BIN

OCT2BIN: Converts an octal text value to binary text.

OCT2HEX

OCT2HEX: Converts an octal text value to hexadecimal text.

On this page

SummaryRemarksExamplesRelated functionsFAQHow does OCT2DEC interpret 10-digit values starting with 4-7?Runtime metadata