Information
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.

Syntax

expression.Delta(Arg1, Arg2)

expression   A variable that represents a WorksheetFunction object.

Parameters

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

Return Value
Double

Remarks

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

Show:
© 2015 Microsoft