# 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 `=`

performs an identical function but returns the result of the comparison as TRUE or FALSE rather than 1 or 0.
**Number1**=**Number2**

## 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:

## Equivalent Excel functions:

DELTA