Documentation/Calc Functions/DELTA

Function name:
DELTA

Category:
Add-in

Summary:
Determines whether two real numbers are equal.

Syntax:
DELTA(Number1[; Number2])

Returns:
Returns 1 to indicate that the two given numbers are equal and returns 0 otherwise.

Arguments:
Number1 is a real number, or a reference to a cell containing that number, which is the first of the two numbers to be tested for equality.

Number2 is a real number, or a reference to a cell containing that number, which is the second of the two numbers to be tested for equality. If Number2 is omitted, the default value of 0 is used.


 * If Number1 is non-numeric, then DELTA reports a #VALUE! error.
 * If Number2 is non-numeric (assuming that Number1 is numeric), then DELTA reports an invalid argument error (Err:502).

Additional details:
DELTA is an implementation of a mathematical Kronecker delta - see Wikipedia’s Kronecker delta page for more information.

A formula such as  performs an identical function but returns the result of the comparison as TRUE or FALSE rather than 1 or 0.

Related LibreOffice functions:
None.

ODF standard:
Section 6.16.26, part 2

Equivalent Excel functions:
DELTA