Formualizer Docs
ReferenceFunctionsEngineering Functions

BIN2HEX

BIN2HEX: Converts a binary text value to hexadecimal text.

Summary

Optionally pads the output with leading zeros using places.

Remarks

  • Input must be a binary string up to 10 digits; 10-digit values may be signed.
  • Signed binary values are converted using two's-complement semantics.
  • places must be at least the output width and at most 10, or #NUM! is returned.

Examples

Convert binary to hex
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
A
Pad hexadecimal output
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
000A

FAQ

Does BIN2HEX preserve signed binary meaning?

Yes. A 10-bit binary with leading 1 is interpreted as signed and converted using two's-complement semantics.

Runtime metadata

Category

Engineering

Signature

BIN2HEX(arg1: Number, arg2…: Number)

Arity

min 1, max variadic

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

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

BIN2DEC

BIN2DEC: Converts a binary text value to decimal.

BIN2OCT

BIN2OCT: Converts a binary text value to octal text.

On this page

SummaryRemarksExamplesRelated functionsFAQDoes BIN2HEX preserve signed binary meaning?Runtime metadata