Documentation/Calc Functions/DELTA

    From The Document Foundation Wiki
    Other languages:


    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

    Related (or similar) Excel functions:

    DELTA