ReferenceFunctionsEngineering Functions

CONVERT

Converts a numeric value from one supported unit to another.

Summary

Supports a focused set of length, mass, and temperature units.

Remarks

number is numerically coerced; unit arguments must be text.
Returns #N/A for unknown units or incompatible unit categories.
Temperature conversions support C/cel, F/fah, and K/kel.

Examples

Length conversion

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

1000

Temperature conversion

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

0

FAQ

When does `CONVERT` return `#N/A`?

Unknown unit tokens, non-text unit arguments, or mixing incompatible categories (for example length to mass) return #N/A.

Runtime metadata

Category

Engineering

Signature

CONVERT(arg1: Any, arg2: Any, arg3: Any)

Arity

min 3, max 3

Arguments

arg1

Any · Scalar

arg2

Any · Scalar

arg3

Any · Scalar

Caps

PURE

Source

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

COMPLEX

Builds a complex number text value from real and imaginary coefficients.

DEC2BIN

DEC2BIN: Converts a decimal integer to binary text.

On this page

Summary Remarks Examples Related functions FAQ When does CONVERT return #N/A?Runtime metadata