DELTA

Formulas / DELTA
Compare two numeric values.
==DELTA(number1, [number2])
  • number1 - required, the first number
  • number2 - [OPTIONAL] the second number

Examples

    =DELTA(3,3) returns 1 because the arguments are equal. In this example, the DELTA function is used to compare two numbers (3,3). Since the two arguments are equal, the function returns 1.

    =DELTA(5,A6) returns 1 because the arguments are equal. In this example, the DELTA function is used to compare two numbers (5,A6). Since the two arguments are equal, the function returns 1.

    =DELTA(A1,A1) returns 1 because the arguments are equal. In this example, the DELTA function is used to compare two cell references (A1,A1). Since the two arguments are equal, the function returns 1.

    =DELTA(A2,B2) returns 0 because the arguments are not equal. In this example, the DELTA function is used to compare two cell references (A2,B2). Since the two arguments are not equal, the function returns 0.


Summary

The DELTA function is a useful tool for evaluating if two values are equivalent. It is a simple, yet effective way to compare two values.

  • The DELTA function can be used to compare two numeric values to check if they are equal.
  • The DELTA function can be used to compare two numbers when there are equal numbers scattered throughout a workbook.

Frequently Asked Questions

What is the DELTA function?
The DELTA function is also known as the Kronecker Delta function. It is a mathematical function that can be used to test whether two numbers are equal.
What is the DELTA function used for?
The DELTA function can be used for a variety of tasks, including filtering a set of values. It can also be used to determine the level of similarity between two numbers.
How do I use the DELTA function?
Using the DELTA function is relatively straightforward. To use the function, simply enter two numbers into the function. The function will then return either a 0 or a 1, depending on whether or not the two numbers are equal.
What is the syntax for the DELTA function?
The syntax for the DELTA function is as follows:
  • DELTA(x, y) = 0 if x ≠ y
  • DELTA(x, y) = 1 if x = y

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV