Documentation/Calc Functions/DELTA

From The Document Foundation Wiki
Jump to navigation Jump to search
Other languages:
English • ‎Nederlands • ‎italiano



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 =Number1=Number2 performs an identical function but returns the result of the comparison as TRUE or FALSE rather than 1 or 0.

Examples:

Formula Description Returns
=DELTA(1.2) Here the function compares the supplied value of 1.2 with the default value of 0 for the Number2 parameter, returning 0 to indicate that the two numbers are not equal. 0
=DELTA(0) Here the function compares the supplied value of 0 with the default value of 0 for the Number2 parameter, returning 1 to indicate that the two numbers are equal. 0
=DELTA(3; 6) Here the function compares the supplied values, returning 0 to indicate that they are not equal. 0
=DELTA(D1; D2) where cells D1 and D2 both contain the value -4.5678. Here the function compares the values in the two referenced cells, returning 1 to indicate that they are equal. 1
=4=5 Here the formula compares the supplied values, returning FALSE to indicate that they are not equal. FALSE

Related LibreOffice functions:

None.

ODF standard:

Section 6.16.26, part 2

Equivalent Excel functions:

DELTA