How to use DELTA Function in Excel

The DELTA function tests whether two values are equal. It returns 1 if number1 = number2; returns 0 otherwise. You can use this function to filter a set of values. For example, by summing several DELTA functions you calculate the count of equal pairs. This function is also known as the Kronecker Delta function.

Syntax: =DELTA (number1, [number2])

The DELTA function syntax has the following arguments:

  • Number1    Required. The first number.
  • Number2    Optional. The second number. If omitted, number2 is assumed to be zero.

Example: Let’s look at some Excel DELTA function examples and explore how to use the DELTA function as a worksheet function in Microsoft Excel:

Syntax:  =DELTA(A2,B2)

Result:

DELTA Function in Excel - How to use DELTA Function in Excel

Based on the Excel spreadsheet above, the following DELTA examples would return:

Syntax: =DELTA(A3,B3)
Result: 0
Syntax: =DELTA(A4,B4)
Result: 0

Syntax: =DELTA(A5,B5)
Result: 1

Syntax: =DELTA(A6,B6)
Result: 0

Syntax: =DELTA(A7,B7)
Result: 1

Syntax: =DELTA(A8,B8)
Result: 0

Syntax: =DELTA(A9,B9)
Result: 0

Syntax: =DELTA(A10,B10)
Result: 1

Syntax: =DELTA(A11,B11)
Result: 1

Syntax: =DELTA(A12,B12)
Result: 0

Syntax: =DELTA(A13,B13)
Result: 0

Note:

  • If number1 is nonnumeric, DELTA returns the #VALUE! error value.
  • If number2 is nonnumeric, DELTA returns the #VALUE! error value.
READ:  How to use IMSECH Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *