Formualizer Docs
ReferenceFunctionsEngineering Functions

BIN2DEC

BIN2DEC: Converts a binary text value to decimal.

Summary

Supports up to 10 binary digits, including two's-complement negative values.

Remarks

  • Input is coerced to text and must contain only 0 and 1.
  • 10-digit values starting with 1 are interpreted as signed two's-complement numbers.
  • Returns #NUM! for invalid characters or inputs longer than 10 digits.

Examples

Convert an unsigned binary value
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
42
Interpret signed 10-bit binary
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
-1

FAQ

How does BIN2DEC handle 10-bit values starting with 1?

They are interpreted as signed two's-complement values, so 1111111111 becomes -1.

Runtime metadata

Category

Engineering

Signature

BIN2DEC(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

Engineering Functions

Generated reference pages for Engineering functions.

BIN2HEX

BIN2HEX: Converts a binary text value to hexadecimal text.

On this page

SummaryRemarksExamplesRelated functionsFAQHow does BIN2DEC handle 10-bit values starting with 1?Runtime metadata