The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

WorksheetFunction.Delta Method

Office 2007
Tests whether two values are equal. Returns 1 if number1 = number2; returns 0 otherwise.


expression.Delta(Arg1, Arg2)

expression   A variable that represents a WorksheetFunction object.


NameRequired/OptionalData TypeDescription
Arg1RequiredVariantNumber1 - the first number.
Arg2OptionalVariantNumber2 - the second number. If omitted, number2 is assumed to be zero.

Return Value


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.

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

Community Additions

© 2015 Microsoft