Documentation/Calc Functions/DELTA
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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. | 1 |
| =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:
Related (or similar) Excel functions:
DELTA