The DELTA function with examples in Excel

The DELTA function in Microsoft Excel is a handy tool for testing whether two numeric values are equal. Here’s how it works:

• Syntax: DELTA(number1, [number2])

  • number1: The first number you want to compare.
  • number2 (optional): The second number. If omitted, number2 is assumed to be zero.

• When number1 equals number2, DELTA returns 1. Otherwise, it returns 0. This makes it useful for counting pairs of equal numbers.

Here are some examples:

1. To check if 5 equals 4: =DELTA(5, 4) ➡️ Result: 0
2. To check if 5 equals 5: =DELTA(5, 5) ➡️ Result: 1
3. To check if 0.5 equals 0: =DELTA(0.5, 0) ➡️ Result: 0

Remember:

• If number1 is nonnumeric, DELTA returns the #VALUE! error value.
• If number2 is nonnumeric, DELTA also returns the #VALUE! error value.

Feel free to use this function to compare values in your Excel worksheets!