ReferenceFunctionsEngineering Functions

DELTA

DELTA: Tests whether two numbers are equal.

Summary

Returns 1 when values match and 0 otherwise.

Remarks

If number2 is omitted, it defaults to 0.
Inputs are numerically coerced.
Uses a small numeric tolerance for floating-point comparison.

Examples

Equal values

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

1

Default second argument

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

0

FAQ

Does `DELTA` require exact floating-point equality?

It uses a small tolerance (1e-12), so values that differ only by tiny floating noise compare as equal.

Runtime metadata

Category

Engineering

Signature

DELTA(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

DEC2OCT

DEC2OCT: Converts a decimal integer to octal text.

ERF

ERF: Returns the Gaussian error function over one bound or between two bounds.

On this page

Summary Remarks Examples Related functions FAQ Does DELTA require exact floating-point equality?Runtime metadata